-
Sales rep monthly Commission not matching with Anaplan 'Check Your Build' numbers?
Hi All Community Members, Despite putting a lot of thought and efforts, I am not able to figure out where am I going wrong. I have set all the Modules and formulae in place but still the numbers for the sales rep monthly commission is not matching with the Check Your Build numbers. Please find below details of my modules I…
-
[Polaris] Allow for the use of Suppress 0's functionality on saved views for Model to Model exports
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: While understanding there are potential updates in the works, an alternative solution for Model to Model import challenges within…
-
Cooking the P&L like a Blanquette: Robust Models in Anaplan
When you start modeling a P&L in Anaplan, there’s a universal temptation: “Let’s just add one more line item, it’ll be faster!” OH NO ! And yes, in the short term, it often is. But after a few iterations, you end up with a model that works… but looks like a stew that’s been cooking too long: too many layers, hard to…
-
Register for our January 29 platform release webinar!
Anaplan's next quarterly platform release webinar will be held January 29, 2026 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of…
-
SUM and LOOKUP | Model Optimization Team series
Hi! Welcome to the Model Optimization team's monthly blog post. This is an eight-part series, following the topics we see occurring most frequently in slow customer models. Our aim is to inform and guide how to build with best practice intentions for these model building topics. Each month, two of our analysts will take…
-
Filtering non-numeric line items
Hello, I have read the below articles on how to filter line items using a Line Item Subset. This currently works great for my use case, except I also need to filter and include non-numeric line items like booleans. The below article runs into the limitation of only being able to filter numeric line items via Line Item…
-
Line Item Subset Formatting
This post is a bit of getting ideas to work around but also see if people are experiencing similar issues. I think it would be a good idea if Line Item Subsets could inherit the formatting and time settings from the source modules that they come from. In the situation where you had a KPI which was a %, a number and a…
-
Error on Copying Model
Hello Community, I had to create a PROD model from existing Dev and UAT models. I created a model using a Revision Tag, and everything worked just fine. However, if I tried copying the model directly, I got an error that I did not understand. It creates a copy, but the copy does not open. Could you help me understand why…
-
Daily Date Format
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it's…
-
Limit on No.of Users
Is there any limit on addition of users to the workspace?
-
Custom Version Implementation
Hello everyone, Working with a client on a model which (due to workspace constraints) is utilizing primarily snapshot versions. After a recent increase in space (pending finalization), we’re looking to incorporate custom versions to all of the modules feeding the P&L for the upcoming budget cycle. Today all inputs, calcs…
-
Commission calculation
Hi, Can anyone tell me whether the below calculation is correct or not? If yes, then can someone please clarify why the quarterly balances are different Thanks AB
-
LOOKUP on Time | Model Optimization Team series
Hello Anaplan Community! Welcome to the Model Optimization team's monthly blog post. This is our last post in an eight-part series, on the topics we see occurring most frequently in slow customer models. Our aim is to inform and guide how to build with best practice intentions for these model building topics. Each month,…
-
Why placing a system module boolean in the main module helps improve performance? (Daisy Chain)
Hello, I have a situation where it feels like the daisy chaining is somehow improving the performance instead? I'll elaborate further below- Context: User enables a calc by selecting a checkbox. If not enabled, the result is 0 to give an early exit to the formula. Approach 1 : Refer to the SYS Users module in the IF…
-
[Guide] Multi Level filter selection on composite hierarchy
If you are using a multi level composite hierarchy as your main reporting list (as you should vs ragged), you have encountered the need to filter it and display many levels of it in many different dashboards. Recently re-discovered a solution that I find quite handy and decided to share it here. Here's the result. As you…
-
Ability to rename/delete native Versions via import action
Anaplan currently provides the ability to create versions via an Import action, and update Version settings via an Import action. Ability to use an action (of any type, Import or otherwise) to do the following: - Rename Versions - Delete Versions Business Need: As we seek to continuously improve our planning process…
-
TEXTLIST() vs [TEXTLIST:]
Hi All, I have read and re-read @rob_marshall's (and Planual's) cautions against TEXTLIST but wanted to check if there is a performance difference between Textlist the calculation function and Textlist the aggregation function? Maybe a performance difference would come basis how the functions read the data? Planual doesn't…
-
Version compare and dynamic module line item description update
This article was updated December 16, 2025. Author: Soumya Bhattacharya is a Certified Master Anaplanner and technology consultant at Accenture. There are at time when we generate some output modules with version comparison feasibility. Although Anaplan has its own Version Compare Function, sometime we need to build…
-
Finding History for List Item Creation and changes
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
-
Dynamic Export Reporting
Hi All, I want to address an query related to exports, In Output model, which is read access for all users & roles.user want to have dynamic export depending on user selection of multiple regions. So for selected regions , they will be able to see the data only for selected regions. Thanks,
-
How I Built It: Codebreaker game in Anaplan
Author: Chris Stauffer is the Director, Platform Adoption Specialists at Anaplan. My kids and I enjoy code-breaking games, and so I wondered if I could build one in Anaplan. Over the years, there have been many versions of code breaker games: Cows & Bulls, Mastermind, etc. The object of this two-player game is to solve…
-
TEXT function to have the option to convert the displayed format
Description of the enhancement: Currently using the TEXT function it will convert the underlying number. For example, if you have: Line Item 1: Number format, set it to 5 decimals - value: 0.0000005 Line Item 2: Text format, Formula: TEXT(Line Item 1) Result: 5-E07 Desired Result (in TEXT FORMAT): 0.0000005
-
Function Movingsum
I try a movingsum function but i get always the next message This is the function that i try And the location that i try to aggregate Why do i get this message the module has a day scale?
-
The power of the ‘No’ version approach in Anaplan
Author: Hanwen Chen is a Certified Master Anaplanner and Professional Services Sr. Manager at Anaplan. Over the years, working closely with Anaplan customers across industries, I've been called in to diagnose and fix struggling models — often in crisis mode. Time and again, one particular design pattern surfaces as a major…
-
Workspace Admin at model level
The ability to select which models in a workspace - where a user is either a workspace admin or not. Currently one is either an admin for all models in the workspace or none. Selective models for workspace admins is not possible. There is a need to select workspace admins for selected models in a workspace.
-
Import for Weekly Data
I am trying to import Historical Weekly Data, but am constantly getting error. Please assist how to import Weekly Data? I tried several times, I have attached Screenshot.
-
Pagination in Management Reports Without splitting Parent Blocks
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…
-
Bulk Copy Action for Production Lists
This idea relates to the Bulk Copy action enhancement released in a platform update earlier this month (Nov 6 2021 release). (Thank you by the way for that enhancement!) We would like the ability to execute the Bulk Copy action for Production Lists. (Currently, the action is limited to only non-Production Lists.) Bulk Copy…
-
Formula to pull dates from History log - Cell Updates
Hi! I would like to be able to pull information about the date/time when a cell is update. Example: If I tick a Boolean field called Final Position to mark a deal as ready to be contracted, I'd like to have an associated Final Position Date automatically fill in with the date that this cell for the deal was ticked
-
Steps for building a model
Can anyone help me understand why the following order of the steps is wrong? I have tried two attempts but still can't get it right!!! Step 1. Build centralized dimensions in the model (time, version, lists) Step 2. Build Modules in the model Step 3. Build centralized Import data into modules Step 4. Create User Experience…