Please consider adding ISBUDGETVERSION() function, similar to ISACTUALVERSION(). This would eliminate having to setup another module with only Versions as the list and creating a boolean flag. All fol…
I have several lists which are needed to be updated by users. So, I have created a module with a flat list (contains numbers 1,2,3.....100) and line items with these lists names. Created saved views w…
Hi I am working on the above activity, but struggles to understand what these formulae mean in the following format (If, then, else) with the sum function in the formulae: IF 'SYS09 Version Details'.F…
Hi I am trying to get the growth rate but adding 'DEM02 Volume Growth Rates by Week'.growth%(lookup:'SYS08 SKU Details'.Product Family) formula but the message is coming as invalid. I tried to lookup …
Hello everyone, I am facing a problem in counting the same names in numbered list. Let me explain with pictures, I have a numbered list :- Style. In this list, every member has different code but mult…
To further enhance the modeling experience, particularly for new modelers, having a hovering tool tip when typing parameters within a function would be useful. It could be structured such that after t…
Hello, I am unsure what went wrong, but my Offset formula for FY20 is no longer populating. I had it working previously, but I don't know where I went wrong. I've been using the appropriate formula fo…
Hi everyone, I have two modules, let's say M1 and M2. In M1, the dimensions are Users and Activity (List of activities). In M2, the dimensions are Styles and Time. I have made a filtered (Style filter…
Hi, I want to improve modele performance. I'm trying to improve IF statement. Here is two statement. Answer1 : IF A THEN IF B THEN 100 ELSE 50 ELSE 0 Answer2 : IF A AND B THEN 100 ELSE IF A AND NOT B …
Hello All, Consider 2 General List List 1 Has A,B,C,D,E,F List 2 Has A,B,C,D,E,F And 2 module in which module 1 have dimension List 1 has value A=100, B=200. C=300, D=400, E=500, F=600 And module 2 ha…
In Level-1 under "8.8.4 Activity: Add Formulas to Size, Margin Report Module" why do we need to change the Margin % line item Summary Method setting to Formula. What is the outcome or output of this c…
Hello i would like to set a basic if nested formula for estimating let's say commissions . If my limits are in units : 0-300 commission 0.2 301-500 commission 0.25 700 and above commission 0.30 Whats …
Dear Team, I would like to ask for a workaround in case where I had to Compare the different versions(Custom) side by side to show the variance and growth without using select. What I did are the foll…
The line item "Data?" in Data Hub Model: SYS14 module was asked to reference SYS12 SKU Details and SYS13 Account SKU filter which were created during Level 2 Data Hub. However, both SYS12 and SYS13 we…
I would love a way to be able to use my custom python scripts and the vast amount of Python libraries on line items in a module, rather than use the Anaplan formulas out of the box. It would save time…
Hi, Although I am following all the steps, 'Cost of Sales' line item shows different value (more than revenue) for the years of 2020 and 2021 in my module. Can you guide me, please? My screenshot: Exp…
Hi, I am trying below formula for Baseline Forecast, its working for FY20, but for FY21, data is not populating as expected. IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic …
I would like to request validation functionality be added to the formula editor in Anaplan. On large models if a formula is entered incorrectly you can wait 8, 10, 12 minutes for Anaplan to process th…
Hi, After I add Formulas to REV05 Price Growth Rates Staging Module, checking my work with the instructions as below: In the REV04 Price Growth Rates module, change the page selectors to US and Chocol…
Hi, I only want to show one year for my balance sheet however when I created the module I see six (we need six years for revenue and expenses). Is there a way to delete the years not needed or is the …
Hi, I have a List 1 where one of its properties from List 2 In List 2, I have a subset which is manually created and not expected to change I need to create a subset in List 1 such that it will be aut…
Hello All, Here I need to find Minimum of values in Expansion. But I dont need zero to be minimum. ExistingExpansion14016181820202222243401400000 Please help in finding the minimum. Suggest the functi…
