Modeling

Breakback function by selected Line Item
Hi Team, It will be great to have an option to select the Line Item which will be taken as a source to calculate phasing for Breakback function. At the moment split is done based on the items, in which I input amount. Unfortunately in some business cases it's required to use another metric for phasing. This can be useful…
Error In Formula - how to understand Circular Reference
Hi, Please see details on the attachment. My apologies for not posting it on the message box I document my inquiries on my pc for future references. Regards,
Disabling line items from being used without wiping previous data associated with the line item.
Hi all, Wanted to ask for a best solution of this question if possible. I am trying to stop a line item being available for selection during a forecasting exercise but I am aware of the fact that if I delete the line item, all data associated with the line item will be wiped. I would like to 'disable' this line item from…
Current User and Current Time functions
For change control there is a need to add the current user and current time to a transaction log. Currently it seems that neither are available as functions although David Smith did comment 9 months ago regarding a current user function "This is something we are actively looking at; to provide a "system" generated list of…
deleting an Item in a list import
Hi All, I was trying to import a list from another but came to know that when i add an item in source list it gets reflected but if i delete an item in source list it does not gets reflected in target list. is there any way to implement that part?
Message before session times out
Hello Anaplanners! Please add a message box BEFORE session times out. "The session will time out in XX sec. Press any key to continue your session". Clicking it will continue session. It is very often when you make some work outside Anaplan, but Anaplan is open on second screen. And in some moment you get message that…
How to get the value in Summary level
Hi, I have two modules: 1. Module01 -> To collect comments from user as a text which published in dashboard: List NamesLine ItemAAText 01AA01Text 02AA02Text 03AA03Text 04BBText 05BB01Text 06BB02Text 07 2. Module02 -> To summary and export the content as CSV. List ParentList ChildLine Item AA Text 01 AA01Text 02 AA02Text…
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…

Modeling

Discussion List