Calculation Functions

Move data Adhoc
Hi, I have a requirement to move data from 1 line item of April to 2nd line item June and the No. of months data should get shifted is based on the user input(adhoc). For Example, if the user selects 3 months, it should move from April to July, if he selects 5 months, it should move from April to Sep. Please can you let me…
Certification Exam
Hi my name is Gabriella and I am having trouble with the certification exam. I need to get an 80% or higher and I am having trouble achieving that score.
How to Set Up a Count Based on an Attribute
This example will teach you how to set up a count in order to count items in a source module based on specific attributes in that source module. Anaplan does not contain a 'Count' function like Excel, but it’s very easy to simulate the same behavior. All you need to do is add in a line item called 'Count' and set the…
EMP02 Module_ Level 1
Data was successfully imported, mapped and formulation was correct as well in EMP02 module W.r.t EMP03 and SYS08 however, the value for Dec 2020 is not the right answer. Now I am confused as in what exactly went wrong. Can somebody please guide? Thanks
Help with Profile lookup
Hello. Stumped here. We are modeling revenue targets at an annual level (clientA = $1,000,000) for 2021. We then need to say - when will we sign the contracts for these deals. I have created an allocation table for this. In many cases, we will sign a deal in fiscal 2020 for 2021 revenues. So the timing of the $1,000,000…
Question on Formula for headers and line items
I am trying to create formulas for a P/L account. I need Line items but I need the formulas across the columns to be different. I cant find any details to this on your website. How is this possible? Gross will link to another module I/C will be Gross multiplied by % with another module Net I am taking the 1st two away from…
List Duplicate Value Issues Hub Model
Hello, In our hub model, we have a sales planning list (L1 Plants) with top level item All Plants. We have other sales planning list (L3 Profit Center) with top level item All Profit Centers We have mapping list L3 Profit Center- L1 Plant with parent hierarchy as L1 Plants. We have a new use-case where profit center rolls…
Using Lookup with offset or lag function
Hi, I have a module (MOD01) with time and 'A' as dimensions and a line item x. In another module (MOD02) I want to have a value of say in JUN 20 I need value of x from JAN 19 based on the Dimension 'A'(by lookup). So which function should I use or how can I use lookup with time period function.
OEG Best Practice: Formula optimization in Anaplan
Taking a few simple steps can give you significant performance improvements in your Anaplan model. Anaplan was designed to be built by business users, with simple formula constructs and no coding required. Formulas should not need to be long, complex or hard to create and understand. All too often, we see formulas that run…
Which function is used to return the first month of time period
START() fn is used to return first date in time period. Which function is used to return first month of time period?
How to allocate Number to list member based on Rank of list member
Hello Team, I have list route which has parent city.Every City can have more that 100 route.every Route has capacity of goods can be transfer.i have ranked these route based on some factor.I want to allocate the demand quantity to these route based on lowest to highest rank considering capacity of route and. Demand100…
Previous of Same Line Item in Customized Time Scale
Hi All, Any suggestion for using the previous formula in a custom time scale? Scenario: Using Previous of same line item in Custom Timescale Module : Products as Dimension, Current Week and Future Weeks (Custom Timescale) Line Items : Planned Order Purchased Order Final Forecast Inv Projection Inv Projection line item…
How to create a Saved View using Actions
Hi Friends, I have a Module. And I want to create a Saved View (of filtering) by Action. Is it possible?
Error in formula
Hi Seems to be a minor one, but I am not getting it..I am getting invalid error for the formula in the attached screenshot. Can you please help to fix it? Thanks Regards Prabakaran
Another Circular Reference Question
I am building a Cost Forecasting Model which uses different methods for calculating the forecasted amount depending on the cost category and the number of years into the future. One of the latest use cases is to be able to taken the calculated cost from the previous year, increase it by inflation and divide by 12 to give…
level 1 Formula given in the activities is giving an error for 'REVENUE' and 'Cost of Sales' Line
level 1 Formula given in the activities is giving an error for 'REVENUE' and 'Cost of Sales' Line items. Open the REV03 Margin Calculation module. Toggle to blueprint view to enter the following formulas for each line item: Line ItemFormulaRevenue'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Sales Price * (1 + Sales…
Single formula for different list items
Hi, I have a list called Apple having items A,B, A+B. A+B should contain the addition of data of A and B. In the module i have a line item called data and applies to Apple list. I have to write the logic for Data line item such that the module shows up values for A, B and A+B should have addition of values of A and B.…
Optimizer - Variables min, max setup
Hi, From the optimizer user guide v01, for variable section, it states the min/max configuration are optional (as below and see the attached full document). So the optimizer has been configured without min/max. However, it flows an error when execute. Then, I configured the Min as zero and it executes successfully. If the…
Suggestions for Creating a Data Point on a Version, Based on alternate Version
Our model has three key types of Versions - Actuals, Baselines, and Custom Scenarios. I have multiple Baseline Versions and many more Custom Scenarios - the end-user will be able to select which two they would like to use. My thought is a drop-down List of the Versions for "Baseline" - all other modules on the dashboard…
TIMESUM Function with aggregation method AVERAGE
Hi, I am using TIMESUM function with AVERAGE as aggregation method for specific from-to period. Some of the cells have the zero values in it, but this functions is considering those zero cells also into count . This gives me wrong average. How can we skip zero cells and calculate average only for non zero values with…
Optimal if statements
I want to make sure that I optimize my if statements, hence some question * If you need to get a maximum of two line items, is it more efficient to use an if statement "if a > b then a else b" or to use the max formula "max(a,b)" * Is there any performance difference in "if x<y then a else b" vs “if y<x then b then a” (in…
Retrieve List as Text used in Module
My model has a vintage or "Book Year" dimension which is being used as a list - we model that particular year's performance over time. I'm trying to create a module to result in a Boolean at the intersection of the Book Year and the Calendar year. I'm using a YEAR(ITEM(TIME)) = BookYear. However, I cannot seem to find a…
Show the current/logged in user in a single line item
Hi Community, I'm looking for a solution to show the current/logged in user in a single line item that has no dimensionality. The use case for which I'm looking for a solution is a dynamic filter based on the logged in user + to calculate totals based on this filter. More specifically, I have a mapping table dimensioned as…
Mapping group
Hi team, I have problem about mapping between entity, entiy(holding) and group. exp: entity H have transaction with entity G, but they in a different group (H in group 3, and G in group 2), we can elimination if H and G in a same group, but group 3 and group 2 in the same group 1, so how to create auto mapping using…
Customised Time Scale
Hi All, I have a module with customised timescale. In Module A, dimensioned 24 Week Custom Timescale. In Module B with no dimension, I would like to get Sum of 12 Weeks from Module A. Any leads, please? Thanks.
Calculation Inquiry
Hi, PLease see details in the attachment. Regards,
Optimizer Exercises - Production Optimization
Hello, I have just done the Optimizer exercises Optimizer: Exercise Walkthrough created by @mark_godfrey , and have an error in the Production Optimization Exercises example. While its possible I messed with the base data, I'm getting exactly the same answer as a colleague. I compared my answer to Optimizer: Use Case…
Need Help Regarding NPV
Hi all, I need to replicate the formula from excel of NPV. I've months of first year that sum up to a Year followed by 4 years. Below is the structure of module. Line items are in version dimension - That's a problem too. col- Jan 20...Dec 20 FY1 FY2 FY3 FY4 FY5 NPV Row having no. list I need to apply NPV on yearly level…
Decimal Format Issue
Hi All, I am facing a strange issue in Anaplan. Hoping someone can help me with this. I have a calculated % field called 'Calc %' The formal this field is set to 2 decimal points and percentage. I have another input field 'Input %' The formal this field is set to 2 decimal points and percentage This field is used to copy…
Circular Reference issue
Hi All, Please see attachment for details. My apologies my post encountered an error so I have to attach the details Regards,

Calculation Functions

Discussion List