-
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
-
How to have first cell in a time period as an input and subsequent time periods as formula
Hi, I am looking to set the first cell in my time range as an input and the following time periods to be based on the first cell. I think I use the offset function for future years but I'm not sure what to do for the input. Appreciate any help with this. Tom
-
Level 1 Exam - Question 5
Need to update the formula in EMP02 with EMP03's info. But I keep getting an error and I have no idea where I have gone wrong... Can anyone point me at the right direction? This is the formula I used... IF Employed? THEN Salary *'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP:…
-
MAX() and MIN () functions over time periods
Currently you can compare time periods using operators '=', '>' and '<' which is great and very useful. But when it comes to comparing more than two dates, it becomes a nightmare to find a MAX or MIN. Unlike with number or dates, you either have to go through countless IF THEN ELSE cases which is probably impractical or…
-
SPREAD Function
Hello Everyone. I am Using SPREAD Function on Monthly Time range. I want to Spread value of only one Single Column. i have used boolean and if else condition for that but not getting it. Spread Function is adjusting All column values. and I want to spread value of only one column.