-
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?
-
Importing Data at multiple level
Hi, I am trying to build a model which contains 7 different levels of product from the region, country, .., brand, to SKU level. The problem is whenever a user adds an SKU for a perticular city it is also automatically added to every other city and occupies a lot of space. How do I solve the space issue and give users…
-
Max value in a time dimension
Hello! I'm trying to get the maximum value of the item test1 in the time range FY19-FY30 and then use that value in an operation in item2. Any idea? In the example screenshot I attached, the maximum value of item 1 is 10 (FY30). In item2, I would like to do the operation 10*line item3. Any suggestions to obtain the max…
-
Formula Help Required :-)
Hi, I've recently been contact by our finance team with the below query - I wondered if someone could help point out where in the existing formula I can tweak to resolve. OLD Formula: NEW Formula: This has resulted in incorrect output in the field known as 'B6', please could you help me work out what i need to amend in the…
-
Get Monthly Data from Yearly Module
Hi! I am quiet new to anaplan and I just got stumbled into this problem. So I have 1 Module which has dimension of Malls(list) and year(list) and line item Revenue. Then from that module I wish to show how many Revenue per Mall per month(the amount should be Revenue / 12). So I create Module 2, which contain mapping of…
-
Select function with subsets?
I have a subset A which is a selection of the Global Customer List. In my module which applies to the subset A, I'm trying to retrieve the Sales for the top level of the subset "total customers" (only the total of the selection of the customers from the global customer list). I tried [Select:'Subset A'.'total customers'].…
-
Help with formula - select both recently item what a list.
Hi. Please could you help suggest how I can identify in an additional column what the both recently (bottom of the list) retention figure is? Most recently figure is the one highlighted below. This figure is pulled through to another dashboard but its currently provide the total sum. SUM is being pulled through to here,…
-
Multiple Sorting/Nested Sorting
Anaplanner, Hope all of you'll are doing good. I had a query if we could have multiple sorting implemented or in other words nested sorting. I have projects dimensioned by Region, Importance and Priority (all are lists). I have currently sorted it based on Importance where Most Important Project is shown first and then the…
-
Movingsum formula
When using list versions, how do I make the movingsum formula include the forecast output for previous months in the calculation of a given months forecast?? I cant include a "previous" function within the movingsum formula
-
Reducing Text Calculations
This article builds on and gives an effective method leveraging techniques and concepts spread across Anaplan. For further reading, please see at the end for those other articles, guidelines, etc. In addition, this article is written with the understanding that the problem that you are solving at hand has no other choice…
-
Need some help with formula
Hello, I am Sylvain. I work in a french confectionnery. Not the unicorn candy company 🙂 I am building a cash flow monitoring and I have to import the bank book in a data module : Only one line item is list formated : "compte" Other are text, number or date And the trouble is about the date. i have to take the data from the…
-
How can I sum the value by list value
Hi All, I have create a module which show the amount in 'Revenue' column How can I sum the value and put in the following module? I have tried the following formula but the result can't be shown (test version.Revenue[SUM: test version.Test]) thanks
-
Second Friday of the month formula
Hi, for your assistance please. How can I get every second Friday of the month? I created a line item Day identifier to get every friday but I need the second friday of the month. Thank you 🙂
-
Lookup Date from Boolean
Hello, I need help to bring in a date from the time settings module based on a boolean (shown below) when the boolean (next day to sweep money) is checked then we need to bring the date into the S02 Module shown below. any help in solving this would be appreciated!
-
"While/Wend" or "Do Loop" Functionality in Anaplan
Within VBA, it is possible to create "Loop & Exit"/"While/Wend" or "Do Loop" functions. This allows formulae to continue running until an answer is produced. Within Anaplan, there are workarounds, but none are truly as flexible, and all have their limitations. Creating this functionality would close the gap on some of the…
-
Allocation Using RANKCUMULATE
* Overview * Before You Start * Allocation Example * Business Problem * Module Overview for this Example * Setting up the CALC: RANKCUM Alloc Module * Evaluating the Results * Further Considerations For a refresher on the RANKCUMULATE formula, click here. Overview The purpose of this article is to demonstrate how to use…
-
Aggregating sales amount based on filter criteria
We have 3 modules where: 1. The Allocation module has Unique IDs(UID1), Time as a dimension and Attributes as Line items 2. The Sales Data has Unique IDs(UID2) as a dimension, Time, Attributes as Line items 3. Output Module which has UID1, UID2, Time as a dimension and Attributes as Line items We have to allocate the…
-
Enhance cell history to show higher level breakback cell data changes when making lower leaf change
When data is input into lower leaf items when breakback is active, the cell history does not update in the higher level summary cells. This can lead to confusion and frustration with nothing detailing where a data change was made, especially when large amounts of data are being manually input. This means some users…
-
Line Item Final Shipping Amount INV01
Hi, I need help on this line item formula. Below is the formula I came up with. Please advice. IF NOT+Submit Purchase Order Request THEN 0 ELSE Suggested Order Amount for the Month NOT(Override Suggested Order Amount) THEN 0 ELSE Override Amount Thank you