Calculation Functions

Level2 Sprint 3 3.3.5.4 Update INV01 to Allow Override of Order Amount
Hi I have got struck up with the activity attached the same, below is the formula which i have done. please correct me if i am wrong. IF NOT Submit Purchase Order Request? THEN 0 ELSE IF NOT Override Suggested Order Amount? THEN Suggested Order Amount for the Month ELSE Override Amount
Growth Percentage Not Being Calculated
Hello All, I notice that the growth percentage is not being calculated in my model despite my being confident that the formulas are correct. Can anyone suggest why this may be happening?
Distribution Capacity Module -3.5.4.2
I am going around in circles with this task. I finally got to a place where I know where the numbers are pulling from into Inv04 module. I need to calculate the beginning inventory by month and distribution center. The data source time dimensions (Inv01) is in weeks and the target in Months (Inv04). Initially, I was under…
Time Filter - Current Period
Hello, I have a module which is NOT Time dimensioned. I have a line item named as "Year Filter" with Time scale as years and Boolean formatted, formulae with different conditions in the same module. When I apply the "Year Filter" in the saved view in the same module, I DONT see "Time: Current Period". It shows specific…
Convert Numbered list into text
Hi, I am having a hard time trying to convert a numbered list into a text value. I have used the NAME() Function, but as a result I get the Number assigned to the list member. Instead I would like to get the text value of the Display name. The reason why I am trying to do it this way is because I need to Concatenate the…
need help for practice
Hi All I want to populate "text line item" which shows string between 1st and 2nd commas of the items in the module. How can i do it. which function should i use here Thank you & regards Yash
Boolean to filter the tarrget module
Hi, I am not able to filter the target module by using the system module time filter.
Creating ISBUDGETVERSION() similar to ISACTUALVERSION()
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 followed by IF VersionsControl.Budget THEN .... ELSE...
How to insert member in a list in between an order using actions?
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 with one column (i.e. List named line item) and imported this column data in the list. Added a "Run import" action button so…
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.
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
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

Calculation Functions

Discussion List