Modeling

IF user Selects any checkbox within 3 booleans then I want to include that in a scope
Hello, I am wondering if I can use the IF formula to say that if a user selects any of the checkboxes within three separate columns (booleans) then I want to consider that within a scope. OPTION 1OPTION 2OPTION 3AX B X C XD EX F Let's pretend this is the dashboard and that the "x" represent a check in a boolean list Then I…
Different ways to do employee transfer in workforce planning model
Hi, I am looking for various methods possible in Anaplan to transfer an employee. My use case is as follows. Employee is tagged to a position/grade and cost center. Employee can be transferred from one CC to another. Target CC currency may be different from source CC. Multi currency Model and each CC will plan at their…
use FIND but also limit the number of characters for boolean
I have multiple store codes that are not within my perimeter and I am trying to create a boolean that reads the start character "S" I managed to reduce the list but still need to reduce it saying that the code starts with "S" but the character count limit is 4. SJ5 SJ6 SJ7 SI5000002 SI5000003 SI5000004 SI5000005 SI5000006…
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
DEM03 Demand Forecast Module
Hi - I've been working through Sprint 2 and have realised that I have completely overlooked the formulas for this module. Please could you assist? I'm not sure if I've missed the step our during the online sprint 2?
Warning on duplicates
Dear All, I am trying one use case in Anaplan and it is as mentioned below: User will input an item in the list formatted line item. If the item is repeating itself then it should highlighted using conditional formatting. It is dimensioned with dummy flat list. Below is the screenshot. List Item1, List Item2 etc. is a list…
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!
Add native search functionality into popup screen for deleting/adding actions/steps in processes
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 processes. Some of these customers' models include thousands of actions, and so it is not feasible for the model builders to…
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…

Modeling

Discussion List