Calculation Functions

New Modeling Experience Idea: New formula editor box to be avalilable in deployed mode
With newest UX for modeling I found the missing opportunity to see the pretty syntax highlighting in models being in deployed mode. The double-chevron icon is unavailable during deployed mode so i can't switch to "New intuitive formula editor so you can highlight syntax to improve accuracy and easily read formulas" which…
Current Day
Actually we have a module that includes a column with dates, and we want that Anaplan identifies if a date from the column has passed or not yet. For that we have created a line item, and we would like the logic behind the formula to be something like this: IF the date (from the column) is prior to the date (current day)…
3 months average of historical sales the year before
Hi, I need to calculate the three months average based on the historical sales data the year before. For ex: Jan 20 Feb 20 Mar 20 - Average values should go under Jan 21. 100,0,100 - 66.7 Jan 21 value Please could you suggest the optimal solution for the same? I have attached the screenshots for reference
Formula help on counting a Text LI
Hi, Need help on how to count the number of times a Text dimension LI shows up under a List LI. We have tried to use the SUM function as well as LOOKUP function, but they did not work. For Ex) We would want to know how many "Merchant Id's" are under each individual 'Legal Milestone" Below are snap shots of the two line…
SUM with Group Number
Hi I want to sum Orders with Group Number. The point is Group Lineitem is not formatted List, is Number Formatted. 1-Nov2-Nov3-Nov4-Nov5-Nov6-Nov・・・Group123123 Order100200300400500600 Odrer(Sum)500700900500700900 I tried Rankcumulate or Sum Functions, But I can't Solve this.
Filtering/Formula based Complexity
Anaplanners, Had a query that i have been stuck on: - I have a module dimensioned by Projects, a List with serial numbers 1-10, list formatted Line item (Project Phase). Ask is, Projects dimensioned as row headers, Serial Numbers 1-10 as columns, Project phase/ Line Item as selector. End User can select a particular phase…
Open source module link in NUX
Suggest to add the "Open Source module" ability to the NUX, incl. the current analysis options available in the old UX. Right now our users can use the open source module function in the old UX whenever they want to dig into the details, see all the underlying formulas/comments, and do ad hoc analysis. Especially, the…
Switchover and Current Month change
Hi, It would be great to have functionality for automatic update of cheking out the Current version as well as changing the Switchover month during the period shift. I was informed that it's no possibility to do it not manually. It can be done e.g. by the switch button or the opportunity to trigger it when the month…
Switch Statement Formula
Adding a switch statement formula to Anaplan to get rid of long nested IFs! This would assist in readability (and therefore maintenance) of complex formulae. Switch statements allow you to test a condition, and assign an outcome to each condition. For instance you may have want to test what mode of transport is being used:…
Subset Formula in General Lists
Hi Team, Can we have an option to have "Formula" in the General Lists --> 'Subsets' section. It would be easy to control Subsets using formulae. Thanks Sathya
"Model Health" / Performance Dashboard
As an external Anaplan partner, we get regularly the question to look into the performance and structure of customer models to assess the health of a model and to find opportunities for improvements. I built for this a model that allows me to upload f.e. line items and gives direct insights on key areas like size, usage of…
New Model Experience - formula editing field improvement
I am sharing here one idea that would make the New Model Experience even better than it is now: Automatic formula indentation / keeping white spaces and new line hits in formula text It would be quite nice to be able to keep the formulas more friendly-looking and let devs to work with them easier. Colours in formulas made…
Standardise Zero Formatting between Modules (& Classic UX) and New UX
When setting number formats, the formatting should be consistent across Modules/Classic/New UX. Below, see an example where a material zero balance is formatted as a hyphen as selected. In the New UX, this appears as a non-zero value. The workaround is to round the output to zero, but Anaplan should format consistently…
Be able to navigate/refresh dashboards while processes are running by other users
It will be a lot more efficient for users to be able to navigate and refresh through the dashboards so at least be able to view the information even if other users are running actions or entering inputs. At the moment, the whole model freezes while other users are processing action or entering inputs. This sometimes may…
Level 2, Sprint 3- 3.3.6 Activity: Test the Shipping Cost Formulas
Hi, I am struggling with updating the formulas of Confirmed PO Delivery and Confirmed Purchase order receipt. Regarding "Confirmed PO Delivery", I understand to replace OFFSET by POST, to push the data to future periods instead of pulling: POST(PO Submitted, -Final Shipping Time Weeks, 0). But I don't get what is wrong…
How to find no of strings in a concatenated string
Hi Everyone, I have line items which is the concatenated string ex - 123,435,234,678,567,987 I would like to find no of strings present ie 6 Could you please help me with this. Thanks Tejaswini
Level 2 Sprint 2 2.3.10-Baseline Forecast for FY21
Hi, I checked the answers related to this topic but I couldn't find the answers. In the DEM03 Demand Forecast module, I have the Baseline forecast values for FY20 which is coming DAT03 Historic Volumes module. However, I don't have baseline forecast values for FY21. I tried to write if/else formula for it but it didn't…
How to get Formula to display the time it is pulling
Hi, Need to know how to get a date to show for a line item that is dimensioned by time, but the module is not dimensioned by time. The formula is working correctly, but can only see the result in a subsidiary view. Need to know if possible how to get the result to show when the LI is not in subsidiary view. If this is not…
Polaris Engine and Calculation Memory Consumption
Exciting news on the new calculation engine. I saw the memory consumption on data https://help.anaplan.com/616ee341-8a5f-4718-8c90-c82e34eca86c-Understand-sparsity-and-density , however how do calculations compare in consumption of memory? There is a 3x usage for data, but if I increase my number of cells, how does this…
Using Boolean Field to Filter
Hi. Currently the Retention (B8) field is returning the sum of all values. I've introduced a boolean field but i'm unsure how to update the formula so that it only returns the value we want (which is always the most recently added). There maybe a smarter way to achieve this?
Formula Help
Hi, Currently I'm trying to make it so if a end user puts in a number from a inputs model I created, then it will override whatever is there in the current month. The formula below is what I created so far but need help getting the input to override whatever was there for that current month. Formula IF End User…
select
when we should use select function . can anybody tell me with an example or scenario .
time formula to show the first 1 -5 weeks of the beginning of a time period in SYS01
Hi! Is there a boolean line item to add to SYS01 so it only shows the first 1-5 weeks in the SYS01 module? it's annoying to see 100 weeks when all I need to see is 10 or so
L2 3.3.5 Wrong result INV 01 for begining inventory and shiping time weeks
Hello, can you help me for find mistakes: 1. Begining inventory 2. And wrong result for shipping time weeks = 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product] Here is my results: I can't find misstakes. Everything seems correct. Thank you.
How to hide parent items in a child hierarchy pulldown?
hi! How do I hide parent items in a child hierarchy pulldown? Can i do it using dependency? Please help me.
Parent - selected item from the parent list
Hello, Is it possible to set up/select of the displayed parent in Anaplan? I have a list of materials (A) whose parent is list (B). List A - MATERIALList B - PARENTMaterial A1_2021Material A2_2021Material A4_2021 When I apply the formulas for Parent: PARENT(MATERIAL) then for Material A I get the result: 1_2021 I would…
Ranking Week Number per Month
Hi Everyone! I have gotten a little stuck using the Rank Function and was wondering if someone would help me out. Background: I have a week dimensioned model. I am trying to rank the dimensioned weeks to produce a resulting module that provides the week number within a calendar month. I would like the rank to reset every…
How to get moving standard deviation
Is there any ways to calculate moving standard deviation? I want to calculate standard deviation in each time period based on moving period. *not fixed period, period is determined by user's input. In Anaplan there is no function to calculate standard deviation like Excel's "=STEDEV.P()", so I try to calculate it using…
When deleting a formula from a module I would like the data in the module to also be deleted.
When deleting a formula from a module I would like the data to also be deleted/removed from the module. I realise the data can be removed manually by selecting the data in the module and pressing delete, but in a module with many thousands this is a time consuming process, particularly as Anaplan only allows deletion of…
parent hierarchy properties
hi! I want to view the properties of an item in the parent hierarchy from the child hierarchy. How can I do this?

Calculation Functions

Discussion List