-
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
-
Help with Formula
Hi, Need help creating a Formula that will bring in a Date from our time setting based on a Boolean LI for that specific Date. Thank you
-
Impact Discovery (Reverse of Drill Down)
Concept: You have entered an adjustment in a cell, you wish to see what line items, cells, items, etc. that are dependent on the entry or are impacted by it. Simply taking the referenced by information and displaying the equations that pull the value and how they change the value (+/-, T/F, Text Change, etc.) Benefits:…
-
How to pick the value from specific version data without SELECT
Friends need your help !! I am trying to optimize the model with the help of cross-references so that can remove most of the formulas from the model (multiple modules will be optimized if successful). Source module with 2 months data April & May months data: Looking for below result in the Target module Note: No version;…
-
inputable table and calculated column in 1 module
Hi Community, I would like to ask some guidance and idea from you guys. I have an input module: Problem: How can I keep FY 19 FY20, FY21 and FY22 inputable while FY 23 to DY 26 will be calculated. Is that even possible in 1 module or do I need to publish 2 modules separately to achieve this? And also for the FY 23 onwards…
-
Circular Reference in Open Orders
Hi All, I am working on a stock rationalization logic where I have Orders as dimension and have to see how the SKUs will get distributed as per the requirements. Attached is a case representing the logic. For the first 3 days, the supply is pooled and then allocation happens for the SKU. However, for Day 4, the closing…
-
Formulas Creation.
Dear All, I just feel nervous when it comes to making formulas. I don't know how to get rid of this and be confident about making formulas. Can anyone please guide me how to create formulas easily and practice them successfully??? Hope someone may guide me!!! -Muizz.
-
Formula Help
Hi, I'm trying to create a formula that will output the date based on a TRUE/Checked Boolean. We are looking to be able to bring in the date for the Line Item '10th of the Month' based off of the Boolean. Please advise on how to make this possible, Thank you
-
Calendar Setup in anaplan
Hi Team, I am having trouble in Calendar Setup, I need a 4-5-4 Setup and my Current Fiscal Year is (FY21 :26 Sep 2020 - 24 Sep 2021). This Setup works fine for FY21 & FY23 as it's 52 Weeks but for FY22 as its a 53 Weeks calendar, Q4 of FY22 is 4-5-5 instead of 4-5-4 as regular setup, Is there a way to account for this.…
-
SELECT/LOOKUP formula
Hello, I need to write a formula to taka data from one module, but only for current month. I can not use LOOKUP function, because dimension doesn't match. e.g. When the formula includes selecting a specific month by SELECT: Month.October everything works, but I want to give the user the option to select the current month.…