Modeling

Subsets as a separate option on the left hand panel similar to LISs
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 similar to LISS with details of the underlying list presented.
"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…
CERTIFICATION BADGES - ANNOUNCEMENT
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 complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
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
How can I change the hierarchy of list parent in module
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 parent '2', where the high level of list 'Test 2' is list 'Test 1' with two list item '1' & '2' I have put the following list…
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:…
Model Map - Imports & data flows
A model map for data flows via imports is needed especially for Data Hub.
Drag/drop and select multiple for reordering actions in a process
When reordering actions in a process, I would like to be able to drag/drop and also select multiple actions at once, the same way we can when reordering line items for a module. Currently, we can only do 1 action at a time, and move 1 spot at a time using the up/down arrows. This is very tedious and time-consuming when…
Ability to search Excel Add-In page selectors
The Excel add-in currently does not allow users to search for list members within a page selector. This almost makes the add-in unusable for organizations with large lists. The solution would be to add a simple search option similar to the Anaplan dashboard/page interface, where users can click a drop-down page selector…
Wider "Format" column / column resizing in module blueprint mode
Please make the "Format" column in module blueprint mode much wider. Currently, list-formatted line items with list names of more than a word or two cannot be seen fully, which makes it hard to distinguish between similarly named lists at a glance. The only way to see the full list name is to click into the line item…
Dynamic names for exports
It would be nice if we could define dynamic parts in the export filenames. For example a timestamp and or information about the selection perimeter for example : define the name like VALIDATED_INVOICES_%ORG ITEM%_%YYYMMDDHHMMSS%.csv that produces a file named VALIDATED_INVOICES_FRANCE_20211005165155.csv when generated
Formula Drilldown Highlight for Relevant Sections (esp. IF statements)
It would be really helpful if formula drilldown could highlight (maybe bold or with colors) the sections of a formula that actually apply in a specific calculation. For instance, in formulas with nested IFs, a lot of it will not apply in a particular calculation because the IF condition is not met. However, that is often…
blue toaster - on large models
Hi Team, As we work with larger and larger models - Data Hub and now Hyper Models the instances of blue toaster errors are becoming intolerable for most people. Even the slightest error can result in blue toaster for 10mins per time. It other forms of IT there is a distinction between verbose error handling and truncated…
Copy a Process
I am frequently encountering cases where i need to copy and existing Process then edit it slightly. Current example is a DEV model is being rolled out to many regions. I need to have a suite of Processes per Region as they are slightly different in the way they update from Data Hub. Right now i have to create a record of…
Working with Processes and Actions
Hi Team, Placing these here as a bulk request: 1. Would like edit/view contents of Action when I find it in a Process. Today I have to abandon the process then go find it from the Actions list. 2. Search Actions when building a process: When building a Process we have to scroll up and down the list of Action (which may not…
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…
Month to Date Format
Spoiler (Highlight to read)I have monthly date as Jul 21, I want that to converted in last date of the month in 07/31/2021 format, is there a specific formula for the same?I have monthly date as Jul 21, I want that to converted in last date of the month in 07/31/2021 format, is there a specific formula for the same?
10.2.5 Activity: Add Employee Expenses Module
Hello, In this module, I see employee details as a code such as #3, dont see actual employee name. Where can I change it? Thanks in advance,
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.
Average of the previous 3 months data
Hello, I have a question, If i want to pull the average of the previous 3 months, how can i do it? Thanks
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
g1 list
please need help with this @Misbah
Add a hierarchy within existing list
Hi, My organization recently has gone through a re-org and as a result, our employee hierarchy has changed from 3 level (VP, director and manager) to 4 levels (CDO, VP, Director, manager). We used to have VP as the top parent for the list. I added another list and changed the new list as top level (parent) for the…
Export Actions in a Process
It would be useful to be able to export the Actions contained in a Process. Currently the only way to extract them is to highlight them all copy and paste into Excel. Add a column numbering 1 to x and then sort on the action name to get rid of the "Remove" labels and then re-sort back on the key to get the Actions in the…

Modeling

Discussion List