Function that will generate random numbers, between specified min & max values. Excel has two functions to provide random numbers: RAND() generates a decimal value between 0 and 1 RANDBETWEEN( x , y )…
Author: Anya Skvortsova is a Certified Master Anaplanner and CoE Lead at Asana. Purpose FP&A is often asked to calculate the impact of variables on the total variance. There is more than one way to go…
Hey Everyone, I'm trying to find a solution in an excel sheet that utilizes an iteration function that I need to replicate in Anaplan. Basically, we take the previous number multiply it by 90%, then t…
I am attempting to calculate IRR on monthly loan cash flows, but my results are different to Excel and make no sense (e.g. Excel give 14.7% and Anaplan gives 418.80%) . All the examples I have seen (o…
Hi, How can i refer Today's Date in a formula so as the values would change every day based on that days date. For e.g. if its 09th june then the formula should give result as 09th june . The next day…
Hey! Welcome to the Model Optimization team's monthly blog post. This is an eight-part series, following the topics we see occurring most frequently in slow customer models. Our aim is to inform and g…
Hi, We have a field that is dependant and i have unticked 'Allow access to unfiltered items' However if you copy and paste a valid (non dependant) value into the field it allows it I have made it go r…
Hi All, I've one scenario where volume needs to allocate by Rank. E. g. We have demand at Parent level i.e Product family level. Now in each product family we have different SKU's & demand should be g…
Hello, I want to set a serial number based on multiple Properties. I'm trying to set a serial number based on a TEXT type key item, but I'm not getting the expected results. I'm trying to implement th…
Looking for a way to sum off a data module based on dynamic user selections. My dashboard has a filter(dimensioned by user). Users select any combination of these dimensions(except amount and account)…
I have an issue with the way Anaplan calculates YTD and need help figuring out a workaround. The YTD value in Anaplan includes the current week, which is NOT how I would like it or need it. i am in a …
Problem statement When using CUMULATE over a list—this is when using the format CUMULATE (x, y, z)—the performance can be poor with anything that exceeds a few million cells. This is because the funct…
I have a requirement where in i have to exclude the year 2020 while calculating the cy projection sales for 2024. Hence when i calculate, i choose a last 5 year period (2019-2023). However in this las…
I have 5 years of data. I need to find the average of the same month for the 5 years. For example, (Jan 19+jan 20+ jan 21+ jan 22 + jan 23) /5. Similarly i need to find for feb, march, April… I used m…
I am trying to pulling billings from a calc modules, the source and target modules are both dimensioned by country but I keep getting this error. Note: I am trying to pull in billings from CALC02 whic…
Introduction Whenever you use a hierarchy, there will often be times when you are required to seek specific information which will necessitate some way to traverse the nodes and map out their connecti…
Hi My current model is using a fiscal calendar e.g. FY23: 1 Jul 2022 – 30 Jun 2023. However, I have a specific use case, where I need to build a module that uses a calendar year e.g. FY23: 1 Jan 2022 …
So i have a nested if statement that checks the status of a shipment. "cancelled" or "storage" first using boolean, the progresses through a series of dates to see which have been added, finally defau…
Hi All, As it is not possible to SUM down native versions is there a simple mechanism to take data out of versions and restate it within a fake version list? I know this is achievable via a series of …
Hi, Below we have 3 line items in a same module, I want to apply DCA in such a way, If I select Country, Sub-region and Region should disable If I select Sub-region, and Country and Region should disa…
Hey, there I'm new to Anaplan and I'm exploring how to smoothly execute a matrix product within it. I have two modules: one resembling a (1,5) matrix and the other a (5,5) matrix. My goal is to perfor…
I have tried to take this exam. There are two formula questions where I provide answers that work based on the information provided. However, the system will not accept these formulas as valid answers…
Hi All, I have a solution using the Rankcumulate function but I want so avoid using it due to the performance issues. So I would like to know if there can be an alternante solution using other functio…
Dynamic cell access can be extremely challenging with long user lists, especially if you want a user's read/write abilities to be dependent on their model role. If we were able to reference a user's m…
Hi, I'm trying to create a formula that will pull values in accordance to each weekday. Below is the Formula I'm currently using. I have screen shots of the Modules I'm pulling from as well. If you ne…
Here is my situation: I have a module that contains a $ amount for a list of accounts , I am then mapping those $ amounts to another module that contains line items that I have in a List. In my screen…
Hi all, It would be helpful if we could control selective access via a sort of system module with booleans. This would allow a relatively standard import to update access that can be done by regular u…
