Modeling
Modeling
Discussion 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 fi…
- Hi Anaplan community, I am a bit puzzled with the result of a formula, which is not giving me what I expect. I have a target module (O4. EB Summary) with two dimensions: a list with a year and a list …
- Currently an error is returned if you copy an item from a numbered list, in which there is another item within that list that shares the same display name, and the user attempts to paste this into mor…
- 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…
- Hi, I am trying to create a dynamic graph for stock overview (see picture below). I created a table with dates in the columns and I have 3 line items. I added a time filter on the module that is trigg…
- 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 …
- Hi All, Here is my number one reason for staying on the old modelling experience: The new settings bar does not have lists. I liked the old settings bar. I did not think it was too big. It was never a…
- It would be really helpful for myself and colleagues if more than just three items could be dragged into the row field whilst pivoting a module. This would also be really helpful for zero suppression …
- 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…
- To improve the model building efficiency & experience, my customers would like Anaplan to add a native search functionality into the popup screen where we maintain (deleting/adding) actions/steps in p…
- There is a quite a bit of scrolling involved to get to list subsets, especially in large models with lots of them. It will be more efficient to group them together and be accessible with an icon simil…
- 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…
- Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you…
- * 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…
- 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
- Hi, I'm figuring if it is possible to change the hierarchy of list parent in module line item For example, I have the following list 'Test 2' with child 'A' with parent '1' and child 'B' & 'C' with pa…
- 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…