Calculation Functions

13.3.4 Activity (Add formula to Profit and Loss Module) - understanding what these formulae mean
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'.Forecast? THEN 'EMP02 Employee Expenses'.Medical Costs[SUM: 'SYS08 Employee Details'.Country] ELSE 'DATA01 P&L Actual and…
level2 :Create DEM03 Demand Forecast Module
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 the SY08 product family as an intermediary module since dimensions are not same but still the message is showing invalid.…
Count in numbered list
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 multiple members has the same Display name property as shown in the picture below. I have a module "Module M1", where this list…
New Model Experience - Formula Editor Function Tool-Tip
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 typing the start of any function, a hovering display lists the required/optional parameters needed. As an example, typing…
Offset Formula Help
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 for calculating it and triple-checked the SYS01 it was pulling from. I was confused when my FY21 values weren't showing up in…
Alternative for SUMPRODUCT
Hello Community, Is there any Alternative function as SUMPRODUCT()... If there any method please Suggest.... Thankyou In Advance. Regards, JeevaK
What Type Of Formats Used in Production Lists
Hi Anyone, What are the production lists Formats.
ITEM function cannot be used on composite lists with Summary of "Formula"
To reproduce: 1. Create a parent list and a composite child list. 2. Create a module with 1 line item with formula "ITEM(Child List)" and list formatted to "Child List". Applies To should be "Child List". 3. Change Summary to "Formula", the following error is shown: The formula for 'mod1'.'item1' is invalid: 'item1' =…
Count Filtered result
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) which filters styles in M2 according to the selection made by the user in M1. If there is no selection made, M2 shows all…
How Nested Formula affect performance
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 THEN 50 ELSE 0 The performance of Answer2 is always better than Answer1? --- Another nested Formula affect performance? This…
Pull values from one module to another module
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 have dimension list 2 I want to pull values of module 1 to module 2 how it is done... other than lookup Thankyou In advance…
Update the Summary Method Setting
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 change? Is that a major impact on output?
How to calculate the 50th percentile
Hello, Do you know how to calculate the 50th percentile (or any percentile) in Anaplan? Thanks! Arnaud
Ability to exclude zero values from AVERAGE calculation
A common requirement we see on customer implementations is to be able to calculate the average of a set of values but exclude zero values. For example if we have the following set of values (10,0,0,8,0), the average excluding zeros would be (10+8)/2 = 9. The current AVERAGE function cannot exclude zeroes and so gives an…
How to Define the current week in anaplan
Hi, Is there a possible way to define the current week in anaplan and current week should change automatically. without updating the cycle
Nested Ifs for Commission Calculation
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 the correct syntax : (if Units Sold>=700,0.30,if(Units Sold>=500,0.25,if(Units Sold>=300,then 0.2,"Zero"))) whats the…
Average Of Flat List
Hello All, Is it possible to find average of flat list. If it is possible please help me with it. Thankyou in Advance Regards, JeevaK
Workaround for select in LIS Collected.
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 following: 1. In my report Module, I made the GL as line item (Revenue, COS, Gross Profit) for some reason. I have also…
FORMULA HELP
Havıng hard tıme on buıldıng formula doıng 1.5.7.2 any advıce wıll work
SYS14 Automatic sum over Flat List not possible
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 were using SKU Flat as dimensions (as instructed in Level 2 training). When trying to reference the two modules, I got error…
Custom scripting line item calculations
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 on export/import data to the Anaplan model. I'm assuming the formulas that are used now are some form of Java or C++? Maybe…
Formula
Hi, I don't understand it doesn't calculate margin/revenue properly. Thanks, Mark
Formula
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: Expected screenshot: Thanks, Mark
Pulling data from one module to another when time is the only matching dimension
Hi, I need to pull period data from one module to another but the only dimension that is matching is time. What formula can I use?
DEMO 03 Demand Forecast. Baseline Forecast formula
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 Volumes'.'Offset Volumes for 1st Forecast Year' ELSE OFFSET(Final Forecast, -52, 0) Below is the Time Ranges selected for…
Validation Button in Formula Editor
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 the incorrect formula. I have seen other application in this space have a validation button for formulas which allow you to…
9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module Error
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 Chocolates. Enter 5.00% for the FY19 Unit Cost %. Then, open the REV05 Price Growth Rates Staging module. Change the page…
How to delete years rather than hiding them
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 best option just to hide these? Thanks, Tom
Create subset in list based on subset from another list
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 automatically checked based on the subset ("GE" in pic above) in List 2. how can I go about doing it?
Finding Minimum
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 function for the same. Regards, Jeevan

Calculation Functions

Discussion List