Modeling

create a formula to show actual and forecast in same line
Hi, I need to be able to show actual data and forecast in same line item. I have an actuals line item, forecast line item, then total view line item. Formula i have written is IF Time filter.Actual Months THEN Actual ELSE Total Forecast It returns the forecast but I should be able to see actual months data, it returns 0.
How do I sum a selection of weeks using a look up
Currently we have a formula that is returning the last week of the month from the look up. How do I get the look up to do a sum of all weeks within the month ? CURRENTVERSION()'.h_collect previous version[SELECT: ..., LOOKUP: Time filter.'H2 End wk']) The H2 End week needs to be a sum of the month ...
using finditem when there are two of the same names in a list each with a different code
Hi, I have a line item in this module called "TPS System Takeout" and in the column next to it "TPS Competitor Report Type Classification" i want it to find the matching name in this list "CTO Competitor Classification Types" You can see that RaySearch was populated because the code for RaySearch in the list is…
Task option in anaplan
What is task option in anaplan ?. Can anyone give brief explanation on that.
How to split vendors into Above a certain amount, show vendor name, else show and MISC.
Doing an OpEx forecast. I have the usual OpEx Account list and Department list along with vendor list. However, on the module, I want to show vendors under the GL. When I do this, it shows all the vendors and I want show vendors above a certain amount. Any idea on how to approach this? I tried a numbered list but I can't…
Linking subsets to a new list
If i have created 5 subsets from a long list and a new list (Subset 1 to 5). Is there a way i can set the formula in my properties of my longlist to command that all items included in the subset 1 shall be tagged as part of the new list for Subset 1 instead of doing it manually? Thanks in advance! Appreciate your help! 🙂
Updation of master data and its reflection in spoke model
I performed an incremental load / full load of the master data(lists) from my Data Hub to a Spoke Model. Now, in my data hub, I renamed a list item in one of my lists and I want to update the same in my spoke model in some way without having to manually change the same in the spoke model. Is there any way to handle this…
Sum by lookup
Hi, I want to sum the total Categories in each Quarter-Year in this module using this column in this other module please help! Thanks 🙂 Amanda
User-Defined templates for new Modules / Lists / Dashboards (instead of a blank canvas)
As a model builder I'd like to be able to create a module template for use when anyone clicks "create new module" so that when any model builder begins making a new module the "empty module" they start from is my designated template. This would likely include various pre-named and formatted line items, categories, with…
Is there a formula to get the current date?
Hi, Is there a formula to get the current date? Thanks, Ana
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?

Modeling

Discussion List