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 sho…
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…
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 fi…
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 Prior…
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 withi…
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 …
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 i…
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…
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 🙂
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 M…
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…
* 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 F…
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 Lin…
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…
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 Sugges…
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 informatio…
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).…
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 …
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 lo…
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…
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 Bool…
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 FY2…
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 sp…
I feel like my formula is correct but for some reason I am only seeing zeroes as values in the DEM03 Demand Forecast module. Is this an issue with the DATA03 Historic Volumes module? To my understandi…
hello guys, i have this module dimensionned by a list. The list is made from differents families and the row axis is made of many lines item and whenever an element is added by the user it insert itse…
hi guys, i would like to know how i can do this in anaplan ( image). i have a module dimensionned by one list. the module is published in the new ux as a worksheet filled by the end users using a form…
Hello all, My team is working on breaking apart a particularly complicated SUM/LOOKUP formula that was built 4 years ago. Looking for guidance anyone may have out there. Here's what the scenario is: -…
Hello, I am struggling to figure out how to distinguish the usage between SUM function and LOOKUP function. Could anyone explain the meaning of the "list-formatted" such as list-formatted line item/pr…
For some reason I can't figure out the formula set up for questions 3 & 4 bonus and phone costs by role. I am wondering if my references are mismatched. Any help on this is appreciated as I feel like …
