Modeling

What if variance in Rolling Forecast
Why is the variance hard coded for just April and May so as to get the variance in the Rolling Forecast Solution in AppHub?
Intraday Best Practices
My client is interested in forecasting their headcount requirements using Erlang-C intraday, with 30 minute increments. I was wondering if anyone could recommend some good instructions/posts on best practices. My going-in strategy was to create a daily module and use an intraday list with 48 list items (one for each half…
percentages of a line
Hi: Apologies for the simple question but we are new at this!!! I need to work out how to work out the % of a item in a line. Using an excel equation it will be sometime like - a2/sum(a2:a5) I am sure it is something very straight forward but having no joy so far!! Many thanks for the help in advance!!
Deletion of numbered list consequences handling
I have created a module where i have some list formatted line items and some number formatted line items (all as columns) along with a Numbered list with display name as 1,2,3,4,.....(manually given by us) to create a blank view for the end user to enter records in each row(for reference; see the below attachment). The end…
New UX - How is version control of apps done?
Hi Is there a way we can version apps on New UX? And can we create DEV, TEST and PROD copies of New UX apps like we can do for models? Thanks Sarbajit Re: New UX Questions
Phased an income over period
Hi I need to phased income over time over period (example below)... any suggestion how I can do that please? Income per month line is where I want to get to!! Thanks in advance Income100200150 JanFebMarAprMayJunJul1204030 2 204030 3 204030 4 204030 5 204030Income per month20609090907030
Convert Date with Week Format to Last day of month with a Date Format
Hi, My model's Model Calendar - Calendar Type is set to 'Weeks: General'. I have a module with a column of dates and the Format is set to Week. In another column with Format set to Date, I'd like to write a formula that will take the date from above, lets say it's 9/2/2019, and output as the last day of the month in date…
Mass Delete / update of user assignments in selective access.
Hello Anaplanners, For one of our customers we have a requirement to dynamically update the selective access permissions to users. As I understand we can only import into Anaplan Users. I tried importing blank data into Users tab for list permissions but it still retains previous data. Further we cannot create a delete…
Dimension Mismatch
Hi, Please see attachment for details. Regards,
Only summarise at lower levels of hierarchy
Hi all, I have a model with the three lists; Cities_L3 which rolls-up to Countries_L2 which rolls-up to Markets_L1. In module I am calculating amounts at the city level using FX rates which are different depending on the parent Country. Is there a way I could summarise the cities to show a sub-total at Country level, but…
Ability to modify Role Access on Modules / Lists / Actions on a deployed model without ALM
I'd like the option to be able to change a module's role access in our live production model, which uses ALM to sync changes from our development model. This would be the equivalent of selecting production data on a list. This option would help because I wouldn't have to push ALL changes (including those still in…
Good Data Leads to Good Decisions
We all know that Anaplan is allowing business users to make fact-based decisions quicker and faster than ever before, but we consistently hear from customers that their data quality is not up to par. “Garbage in, garbage out” or “dirty data” are phrases you’ve probably heard. I hate to be so blunt, but data will never be…
Retrieving last date with value
Hi, I have a module where I have time as dimension, as well as a list of equipment. The module is on daily level and has a value of either 1 or 0 depending on if the equipment is in service or not. These values are imported from another Anaplan model. I then have a second module, where I have the same list of equipment as…
Function for Format Conversion
Hi all, I just want to share a simple table as a summary of the functions needed to convert data across formats in Anaplan. Is not a big deal, but I hope it comes in handy to some of you. * Transform Text into Date is not that straight forward since it is needed to chop the date in 3 chunks: the day (DD), the month (MM)…
Select parent level
I would like to see a formula similar to parent but "inverted". When I have an unbalanced hierarchy and need a parent a similar level I would like to choose level from the top instead. example: invparent(item,3) which would always give the level 3 item for all parts of the list instead of trying to find our a way to get a…
Non Parent/Top Item List Relationship
Hi team, I have a Currency list that has no parent/top item & an input module whereby the user will enter the data into the Currency dimension. In a secondary module I want to convert all those currency values entered by the user into 1 currency. I can only get this to work at the moment by not having a currency in the 2nd…
How to apply sum function(or any) on time line item?
Cee-Cee shop module is where my Spool & Cages incoming, Outgoing happens In Cee-Cee shop module i have Expected Cee-Cee return date which is nothing but (Date + Lead time days) Now in Expected Repair item return module, I have expected line item - What I'm trying to do is or requirement is to take from the incoming(Cee-Cee…
TIMESUM with Generic Weeks, and other summation options
Hi all, I thought I'd just summarise some of my learning experiences with summing data using Generic Weeks, since I couldn't find an article that brought this all together. First up, as you will probably know, you can't use the ordinary SUM function across the timescale if you've chosen Generic Weeks, as there are no…
automatic backup
It would be very good to have the possibility of executing an action or process that makes an automatic backup of the model.
Order of Lookups and SUM in formulas
Hi, I was going through a best practice video which mentioned that the order of lists in the module can help improve the performance if the lists are ordered similar to their order in General Lists section (because indexing becomes easier for the engine). I was wondering if there is a similar best practice when it comes to…
how to truncate concatenated strings with a separator
Hi guys, Assuming I have a concatenated strings with different length but with the same separator.. To illustrate: I have company code+ledger+asset code but with "-" in between.. This 3 do not have the same length.. Assuming here are my data 1. 111-123456-12456 2. 1111-1234-124 3. 11-12345-234 How can i get the mid…
using lookup formula, it works, but shows the result as 0
hey I'm doing a lookup off the employee drivers by role module and employee details module to calc employee expenses, but returns a 0 for the result, anyone have insight on this?
Filtering of subset based Module based on full list
If a module is based on a subset I would like to have opportunity to able to filter it based on the other modules which are applied to original lists. currently i need to create a new line item which will be applicable to that specific subset. an example of application is a dummy timescale (which contains for example 7…
Pulling data from numbered list into a module
Hi All, I need some advice/guidance. I'm building a tiny model that looks at the number of components used in products. We have one component that can be used in 5/6 products. The end result that I'm trying to achieve is a module that shows me data by components. What I've done is created a numbered list called "infeed…
Customize Branch Copy Action
Branch copy is a very powerful action, widely used in what-if-scenario analysis. It can also be used to copy, for example, promotion events. The problem is, when we create a copy of a completed promotion event also the status is copied indicating that the newly copied event is also completed, which obviously is not the…
HyperBlock Performance Improvement: TRUE-->TRUE change
The Anaplan platform leverages a patented in-memory, Java-based, planning engine for calculation called Hyperblock", as we can read in the CIO Guide White Paper on anaplan.com. The engine allows to rapidly calculate billons of cells. It is also important to understand that it recalculates only what needs to be…
Defaulting filters in Assign Action Screen
Assign functionality can be used, for example, to add products to customers. But how will we make sure, that only active products will be added? We can define a filter in assign actions (we can't use Boolean as a filter, but we create a list formatted property for that purpose). The main problem is, that when we open the…
Enable item insertion when the dashboard item is selected whether or not the header has been selecte
If you publish a numbered list to a dashboard so that a User can insert items and then enter property values, it works fine as long as there is at least one item present. However, if you clear the numbered list then the option to insert an item is greyed out and I have found no way around that. Even if there is one or more…
Performance of line items calculations with cell count 0
Anaplan platform gives to modelers great flexibility in terms of how it is used, once in a while leading to situations, where modelers design solutions, which were never considered by Anaplan Platform developers. One example like that is usage of a single element list with subset as a module dimension - to turn on or…
"is first occurence" gives me unwanted output. cant find a solution
Hello guys, my colleagues plan on IDs. After they are finished with their planning I want to build a profit and loss hirarchy by creating codes based on different inputs. Those codes have to be imported into a list. The problem I am facing now, is that they can plan totally different topics on the same ID in the next…

Modeling

Discussion List