Calculation Functions

Lookup two different dimension
Hi, I have attached a sample Modules that I have in my model: I want to retrieve the Quantity data from Module 1 to Module 2. but they have different dimensions. As you can see below, the dimension for Module 1 is Unique Code List, and Month (time) but in Module 3, the Dimensions are Active Skus , and Accounts. I tried…
Sales bonus based on hire month
Hi, I have a requirement to have sales bonus based on the hire date - For example, if an employee is hired after sept of 2022, the employee is eligible to get sales bonus only after Feb 23 onwards. If the employee is hired after sept 23, then s/he is eligible only after Feb 24, etc.. If the employee is hired in or before…
Time functions Polaris
Item(time) function not working in Polaris my time scale is month. Format is year. need to populate year Thanks
Formula help
I have 4 modules as shown in the screenshot. When I make an Override only for Brazil it is being carried into all of LATAM in Module 4. In module 4, the revenue is pulling for all the countries when in-fact it should pull only for Brazil. How do I fix it?
Display SKUs based on selected Type(parent)
Hi, I have a module name : NPI Enrolment -- this is to encode New SKUs which currently is in a separate list called New SKU(List) I also have another module called Reference Sales -- the goal is to get the sales from existing SKUs since New SKU have no sales yet. In my Reference Sales Module, I cannot display the SKUs…
Ability to update formulas of List Properties just like line items
To use the List property in formula, one need to type out the whole list name including property name, that is a cumbersome process. Allowing Reference of List Properties, will save MB time and efforts in wrong typing of name.
Searching for a certain role
In my data I have teammate roles, their names, the month that they were in that role, and the facility that they serve. In one module I have all this information listed out. I included a picture with the data I have. I didn't include the teammate names because that is sensitive data, but there is a column left of facility…
Sum calculation not visible when highlighting cells in expanded view
Currently in an Anaplan dashboard, if you highlight cells, you can view the summation of the values (see image below). However, when you expand the table to fullscreen, the summation does not show (see image below). We kindly request a product enhancement to allow for summation calculations in an expanded table view.…
How can I get the average of months for prior year?
I would like to get the averages for a line item using prior year month values. I can use the formula below but I don't like the idea of hardcoding. Is there another way I can do this without hardcoding? The current formula I have is: LAG(<source LI>,12,0)+LAG(<source LI>,24,0)+ LAG(<source LI>,36,0) / 3
SYS07 Sales Rep Details (Length of Service List Line item)
Hi, having trouble to find out why some of the result are blank Thanks, jehular
Filter by page selector
Hi, I want to Filter List by page selector. I have this two tables. Region List is a parent of Country. I want to achieve this below image. When I select Europe in Region table, Country table is filtered Europe Region. Is there any way to do this? I wish I can get List Item which I choose now.
Write Access Driver to Parent Item
Hi, I want to use breakback function and Write Access Driver. We have Country List which has Region List as Parent. And Users input to "Adjust Lineitem" and it set as breakback. In this table, I want to users can write "Adjust" by Region List, and cannnot write by Country List. I want to set a Boolean Lineitem to Write…
Breakdown by proportional division
Hi, I want to use breakdown function. Breakdown has equal division function as default. (Image is Adjust(normal)) But I want to breakdown by History rate. case) Japan : 1000 * (200/800) = 250 Are there any way to achieve this by using breakdown function?
Day Timescale and Date formatted line item
Hi All, I have a model with Week General time settings. Module 1 uses Day timescale and Module 2 has Date formatted line item. How can I lookup line item in Module 1 using Date formatted line item in Module 2? The Day timescale in Module 2 appears as 10 Apr 2019 while Date line item in Module 2 appears as 4/10/2019. I…
Performance of Comparision of Boolean using = sign over using NOT function
Whether using IF Approved? = TRUE THEN 1 ELSE 0 is good or optimizing the formula as IF Approved? THEN 1 ELSE 0 where "Approved?" is a BOOLEAN format line item. Same goes for, IF Approved? = FALSE THEN 1 ELSE 0 IF NOT Approved? THEN 1 ELSE 0 Please advise to optimize performance of the model.
Formula to sum with condition
Hi, I need to sum the elements of one column based on an element "text" of another column. This text element isn't in a list so I can't use the function "Select". What formula can I use ? Thanks ! Best regards
3.3.5.2 Inventory Ordering Module Formulas - Beginning Inventory issue
I am getting the formula right - IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory However, I am not getting the desired results. I am getting IF and THEN part correct but i am not getting ELSE part correctly i.e., ELSE…
Timestamp using data write action
It would be nice to have it displayed the action run time stamp or a Boolean check timestamp using a data write action in New UX. we can bring by text formatted line item as we dont have time stamp data type. it will help to calculate several time related calculations. which will definitely help in several use cases.
3.4.3 Activity: Create Country Summary Module
Hello, This is my proposed formula for the Flag Count line item - taking into account the mapping for both country and product family that are dimensions in the INV02 module 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In, SUM: 'SYS08 SKU Details'.Product Family] When…
stuck on level 2 sprint 3.3 activity
hello i need help, please !!! I am stuck on level 2 sprint 3.3 activities I don't understand why i can't have the same results that course My results My formulas Level screen reference
Accuracy of calculations
Hello everyone 🙂 , we have two model builders who applied the same formula but with a different order, but since it's multiplication and division, the order doesn't matter. Unfortunately, I come across two different numbers. How accurate is Anaplan in calculations? Here an article i found Precision differences and large…
Distinct count of Agent with comparing Date and Program
I have Module in DataHub without any Dimension I need to create a column that count distinct (Unique) Value of Agent Program and Agent are in Text Format DateProgram Agent Distinct Agent…
List property formula functionality to match module line item functionality
Hi Anaplan! It would be great if when you are entering a formula within a list property/attribute you can select another list item property by clicking on it instead of having to enter the name each time. This would also need to apply when referencing a modules line item, so clicking on the line item when a formula is…
NPV Calculations
is there a way to calculation the NPV on a rolling basis? So basically I would want the NPV to be calculated on a quarterly basis for the current quarter and forecasted quarters. per the screenshot below, for Q4 2019, i want the NPV from the current quarter to Q2 21.
Version Formula in Module
Hi, Is there a step by step guide on how to use the Add version formulas to line item subsets in module blueprint ? I don't see any line item in the left box. Thanks, Tom
3.3.7.2 Add DCA to INV01 Inventory Ordering
Hi - I'm sorry, I'm really sure sure what the section is asking me to do?
Error Message
Hi, I have an error message that keeps on popping up when I'm trying to create a formula. I'm trying to multiply the two line items together. Please advice. Image is attached. Thank you
Time Spread (Reverse Count from point in time)
Hi, I have a problem I am finding difficult to solve. Hopefully, someone in the community has encountered this before and can provide some clever solutions to this. First of all, the modules I am showing here are just to explain the problem I am trying to solve. The actual modules are on a very large data set so I need to…
L2 2.3.10 Wrong Value
Hi - I am at the L2 training segment 2.3.10. While my formulas are all correct (I think), I am somehow still seeing an unexpected value as an answer. Screenshots below on my formulas. I'm not really sure what's wrong here. Any help?
Formula
Hello, Quick question: How can I calculate the Volume between FY17 and F21 in the other module? For example, the difference between two years. Note: Just Volume is a line item. Please see the attached. Thanks, Mark

Calculation Functions

Discussion List