Modeling

Salary Calculations
Hi, Can someone help me to understand the salary calculation, how it will calculated on the basis of merit increase% Thanks Shweta
Google Chrome Extension to make long formulas easier to read
Hi everyone, I created the chrome extension Anaplan Formulator to make long formulas easier to read in the native formula editor. The extension inserts a return before and after each IF, THEN, and ELSE in the formula. Please take a look and let me know what you think! Thanks, Ryan
Skip hierarchy levels
I'd like to have option to skip hierarchy levels in a module when publishing it to a dashboard. Currently you can deselect some of the levels but it always leads to Hierarchy collapsion (please see screenshot: the brands are disconnected from the categories because the intermidiate level was deselected): I would like on…
Synchronize to Specific Level of Hierarchy
Ability to select a level of the hierarchy to show and have synchronization based on selection. Ability to have separate tables built out for a hierarchy to drill down into without creating separate modules. If we could select the level to show in addition to having synchronization based on selection it would eliminate a…
NPV Formula with time adjust.
Hi, I need to replicate this formula from excel: =VNA(wacc;cash flow)*(1+wacc)^0,5 Could you please help me? Thanks Nacho
Drill to transaction
how to do drill to transaction in other source system
Aggregation function for non-list data type
Currently the aggregation functions only work towards list data type. This disallows to fully replace VLOOKUP function in Excel. Please add at least some additional functionality: for example to search for FIRSTNONBLANK using text data type. That would allow to more easily deal with data without need to maintain excessive…
More options for TEXTLIST
There is currently no way I can use TEXTLIST function with both unique values AND mapping. * Either you can use parenthesis function with UNIQUE property * Or aggregation function with mapping but with entries repeating. To sum up both use cases are incomplete. Please add option to turn on both features at the same time: *…
Simple check on Data
Hi, I think this should be an easy solution, and maybe i am trying too hard Consider the module below, data coming from a list start date, end date, and a count (1 = yes, 0 = no) I want to populate Previous YN with a 1 IF the promo count was 1 for the previous period. So in the example above #2: 31/01/2018 to 28/02/2018…
Ability to use Concatenate (&) in a Select Function
I would like the ability to add an Concatenate to Select Function. For example SELECT: VERSIONS."Budget "&NAME(Current Year). As we have multiple Budget Version, the current version in play and the future version. So in our variance reporting module it would select the correct version as budget. Similar with forecast ……
Mean time interval between transactions
Hi All, How to calculate mean interval between transactions per material in the following module which is one dimensional. Thanks Arun
Formula Help - Check on only entry
Hi everyone I need some help with a formula. I want to create a line item (LINE ITEM B) to check that another line item (LINE ITEM A) only has an entry in one period. The line item that I want to do the check on is a manual input and has a numeric format. I basically want the model to flag an error to tell me if there are…
Delta load for Numbered lists
How to implement Delta load for Numbered lists in Anaplan ?
Formula
Hi Experts, I am using two line items, Both line items are text format. Line item 1: FCST_1 Line item 2: FCST_2 For suppose FCST_1= 5.4591 Then By using FCST_1 we need to calculate FCST_2= 5,46(Rounded value AND instaed of dot we need replace comma) To do the requirement i write the below formula FCST 2= IF FCST_1 = 0 THEN…
Running balance of a numbered list
Is it possible to get the running balance of a numbered list? my numbered list is a daily cash transactio and i need a line item taht will get the running balance per transaction. Thanks!
Incremental Load
how to do incremental load for transactional data?
NaN formula
Hi, Please see attachment for my inquiry. Appreciate the help on this. Regards,
Read Only for submit once approved
Hi, I have 2 line item, Submit and Approved, Both are Boolean format. Once an Item is both checked for Submit and Approved as True, I need Submit(line Item) to be read only, i.e it should not be allowed to unchecked again. Thanks & Regards, Asha
Issue with Formula
Hi Experts, I have 2 issues with my formula, 1. I have written a formula to line item "Territory Code as Number" = IF Active Assignment? AND LEFT(Territory Code, 1) = "G" THEN VALUE(RIGHT(Territory Code, 2)) ELSE VALUE(Territory Code). I have considered the below things to the line item. Format = Number Time Scale = Not…
How to find the mid point of a mid point between 2 dates
I have start and end date for an event. I would like to find what the mid point time period between these dates is. Is there a formula I can use to do that?
How to import to a numbered list from a numbered list in a different model?
How do you import to a numbered list from a numbered list in a different model - using the 'connect to Anaplan model' function? The aim of this is to store the lowest level of my organisation's hierarchy as a numbered list - this is needed as some of the organisation unit names are duplicates. At the moment, I get the…
Hide List Property Columns when view is on Dashboards such as the 'Parent' or 'Code' or propety
Hi Anaplan, It would be really helpful if it were possible to hide the 'Parent' 'Code' or any property columns on list views published on dashboards. This is to prevent any destructive inputs such as changing the hierarchy by accident. Thanks, Usman
Prompt to open list when creating
I am adding a new list, it would be useful to either open the list immediately afterwards (or prompt for opening). This could work in the same way as creating a module. The logical next step to creating a list is to add members to the list. It would be more efficient to be able to add members to the list as part of the…
Username is blank in model history
Hi, Is it possible that someone has made changes in model but their username is not visible in model history. Activity records are present in history but username column is blank for some records? THANKS
Disabling boolean check for only particular member in a list
Hi, I have a flat hierarchy, which is used in a module. A Boolean line item is created in same module, but I want my Boolean field to be enabled only for particular member in the dimension list and disabled for all other members. Regards, Madhu
Numbered List import issue while using 'Combination of Properties' with "Month" as unique identifier
Use Case and Workaround: I am trying to import data into numbered list using "Combination of Properties" option. The catch is, my only unique identifier is "Month". I have records for a GL Account by Cost Center by Product and by Location. And will have same combination coming in as Trial Balance records but for different…
1:1 relationship for sales title and plan ID will now be 1:many
Hi, We have a list called Sales Titles which has all of our Sales Titles. The code for each sales title is a plan ID. 1:1 relationship. Some sales titles have the same exact plan components, but just different plan IDs. We have a request that now they are reducing the number of plan IDs as some sales titles have the same…
Code for Numbered list
When I want to create member(s) in a Numbered list, I can create it by inserting in the list (without having to mention a code) or through 'Create' action without having to specify a code at the time of creation. Why does an import action into a numbered list needs a code or combination of property for creating list…
What are the best practices to understand a model?
HI, From a model builder point of view, what are the best practices to follow in order to understand an Anaplan model built already when there is no documentation available (no design docs) nor technical knowledge transfer? Thank you in advance!
How to add prior year data value
Hi, I have a line item Headcount and my current year is FY17. For FY18 I need headcount value to be prior year headcount and FY19 to be FY18+FY17 headcount value. Can I please get some guidance. Regards Madhu

Modeling

Discussion List