Calculation Functions

Behaviour of SEQUENTIAL parameter in RANK function
Hi All, We have a requirement to sequence items in a export and we've been using the RANK function to achieve that in a similar way that is listed in several posts in the community…
Create Demand Export Module and Create a Saved View - DEM04
Hi, I am trying to do this activity: Here is what I did for DEM04: And this is my export view: There are two problem comparing with the expected result 1. The SKU Code and Location Codes does not appear in my saved view.( I put all line items as column) 2.The Demand amounts are not correct, here is the expected view: I…
Level 1 Lesson 4.6.9 File Mapping Guide
Hi Everyone My import was successful however it doesn't match the guide Here's the result of my mapping Here's the guide Hope to hear from everyone soon!
LEVEL 1 EXAM MODEL BUILDER ACTIVITY 5
Hello everybody. i´ve been stuck in this activity since yesterday, a create a Role list, With a top level of all roles, then i import the new data in the SY08 EMPLOYEE DETAILS with the extra role line and i don´t get any issue with the data. The thing is that when i try to change my formula for the BONUS, CAR COSTS, PHONE…
Trying to filter by a Yearvalue with a nested Lookup to pull list parent
I have a module that we export data from using two system type modules that allow a user to filter their export by version and by year (time) using boolean selection boxes (checkboxes). I want to add the ability to filter by a third category, Division. The way the module is currently filtering the data in the export action…
Profile Function for Revenue Recognition
Hi everyone, My company uses Anaplan for all budgeting and forecasting and we recently discovered an issues as this is only our second year. We have 2 metrics "Bookings" which are sales associated with contracted revenue, and "Installs" which are when the booking begins being recognized as revenue (as the product is…
POST formula in SPRINT 3
Hello, Can someone help me to understand why for "Confirm Purchase Order Receipt" line Item, "POST(IF NOT Submit Purchase Order Request? THEN 0 ELSE Final Shipment Amount, Final Shipping Time Weeks) " is not a correct answer for the formula to use? Regards
Restriction line item based on another line item
HI all, I have a module Fnem00, here we have to Select the Account and program. Based on that we have provided the DCA to enter the values in Fnem01. Now if I delete the Account and program in Fnem00 the Values in Fnem01 is Values are not getting erased. How can i fix this?
How to keep the input value after switchover
Hi All, i have a question about switchover Currently the forecast period is started from Jan 23 and i have input a $10 in this period however after i have switchover to Feb 23, the input value will gone. how can i resolve this issue? thanks Before switchover After switchover Blueprint
Anaplan natural rollup is not equal to sum of values from its children
Hi, fellow Anaplaners I observed some weird behaviour of Anaplan natural rollup (meaning set line item as number & sum as summary method, then parent item will take sum of all its children's values). I have 2 line items here: 1. Commercial input is number formatted; no formula, is for planners to manual input forecast…
Improved Formula Editor/Bar
If the following features could be added to the formula bar in Anaplan it would make model building and maintenance a lot easier! * Colour coded statements and keywords (e.g. IF THEN ELSE, line items, constants) * Ability to indent and enter new lines. Particularly useful for IF statements * Keyword autocompletion *…
Activity 8.8.2
Hi, I am unable to add the right data in Fy 21 and FY 20 in the REP 01 Country Margin Report Module. I have added the exact formula as well but it is showing the correct answer in only the FY 19 rest two years are incorrect. I have check my other modules i.e., the referring module for this formula is also correct but the…
UX dashboard filter not defaulting to current user
In an attempt to reduce the size of a line item(used for dashboard filtering), we created a dummy list that contains a small subset of people. The subset of people has selective access enabled. I then used FINDITEM to link the Users list to the subset. The linking worked successfully. However I ran into an issue when I…
Which approach is better? (Related to Text, Lists and Formulas)
Hi Everyone, I have a module which is dimensioned by one list. It has around 60k items. In this module there is one line item (Main_Text). I want to pull a string from this Main_Text line item and then use Finditem() function over that string. Right now, the approach that I am using is to calculate them in two different…
Size of model increase.
Hi All. I have a Prod model. which has been gone live Aug-22. Now its size increasing every month. Our Total Model size 200 GB .Last month we had 160 GB this month its increase 176 gb. Now its occupency is above 80% .now we want to incease workspace. Now, i want to know how much space should i purchase. What are the…
formula summary
HI All, Why we use summary as formula. what are the scenarios that we use this ? what is the outcome of it?
Rankcumulate - unexpected result
Hi, I am using the rankcumulate function but I am getting some really unusual results, wondering if anyone could assist as I have no idea why this is occurring? I have attached the formulas and also the results. Thanks in advance
Moving values from one module to another while Line item is being used as Dimension in other
Hi everyone: Module 1: Dim - Entity (Aus 1, Aus 2....) LI - please refer below as (numbers) Module 2: Dimension: LI of first module , Parent of Entity (Aus..) Line item: Amount (which will have the values from the first module) I am getting same value distributed across all the Dim 2. Can someone help me out in this case…
Find an item in chart with 3 conditions
Input Road 1 France Germany Type A Road 2 France Germany Type B Road 3 France Italy Type A Road 4 Italy Germany Type A Question Hello, I would like to know how to get back into a module the correct road. The road depends on three conditions as above. For example, if I am told that the road is France Germany Type B, I would…
[Part 2] Using line item subsets for dynamic error messages for user input validation
* Step 1: Create a module for your error messages * Step 2: Create your line item subset * Step 3: Create a System module to store metadata associated with the validations * Step 4: Create a module and use COLLECT to summarize error information * Step 5: Create an Output module to display the error messages and other…
Rank Formula || Need to Cumulate in Reverse order
Hi Everyone, I have a module dimensioned by List 1 and Time (Quarter). There is one imported line item (List formatted). I want to number these imported cells data according to the quarter. For example:- List item A has values in the following quarters Q1FY23, Q2FY23, Q4FY23, Q1FY24, Q3FY24 (other quarters are blank) so I…
Quick Sum Bar for Maximized Card Views in NUX
Hi, Quick sum currently works for cards on a board, but does not work when a card from that board is maximized. This was a feature in the old UX when a module on a dashboard was maximized. We have a good deal of users asking for this feature.
Rank Formula - Excluding Blanks
When looking at the page for the rank formula, there is a callout that says "Remember that if a source value is blank, the blank is ranked first for ascending order and last for descending order.". I am wondering how blanks could be excluded from a rank formula where I need to sequentially rank records based on when they…
Break text into new line
Hi Friends, What is the command required to break text into multiple lines in a Dashboard.
Move data from fake time period to real time period (For restriction of drop down selection on time)
Hi, I want to move the data from fake week to real week. I tried with multiple formulae and still getting errors. Request your help. Please find the screen shot of requirement below: And I have a mapping module as below: And my fake week list is as below: Note: The reason why I have created a fake time is period is that my…
LEVEL 2 - SPRINT 2 - 3.3.5.2
Can I know if the formulas are right and I need help with the other formulas
10.2.1 Add non employee expenses module
Hi Community ! 😀 I'm learning the training and I completed everything but the formula is what holding me back for the past 30 minutes.. So below is what I have : & from the training I am suppose to have ... Thanks in Advance for your patience ! @Akhtar.shahbaz
10.2.2 Import data into Non employee expenses module
Hi community ! Please bear with me as i have a learning disability. I keep receiving this error message ... I would greatly appreciate the assistance. Thanks in advance ! @Sowjanya @jagadishdash
Adding a common line item associated with a single list item
Hello all, Can you please advice how to add "line item associated with a single list items"? In the attached screen shot, •MU approved/agreed and •GS approved are list items and I have created a nested dimension in module, such that the line item is common for these list items. Now I need to add, the columns highlighted in…
2.3.10 Activity: Create Demand Forecast- Need Help
I'm not getting any values for my 3 line items after the baseline forecast. I cannot figure out why this is happening. I see growth percentages in my source modules, but they are not being carried over in my formula for my "DEM03 Demand Forecast Module".

Calculation Functions

Discussion List