-
How to estimate the size of a model
Hello, I would like to find an app to estimate the size of a model I can't find it on the App Anaplan Agile THank you for your help
-
Fiscal Year 2025 and 2026
I am trying to configure Week 52 for the year 2025 to span from December 20th to December 31st and Week 01 for the year 2026 to cover January 1st to January 9th. Despite my best efforts, I haven't been able to find any articles or resources that provide guidance on setting up a customized fiscal calendar in this manner. I…
-
not a recognized line item
We are repeatedly getting the not recognized line item error when building out simple formulas sing line items all contained within the same module. In the screenshot below A-3 references A-1 + A-2 and all are clearly line items, this is happening when selecting the lines items with the formula editor and typing out the…
-
UX Enhancement: Red Font Toggle for Negative Numbers
In most cases, especially when adhering to accounting principles, it's preferred to display negative numbers in red font, similar to how Excel handles them. Currently, achieving this in Anaplan requires setting up conditional formatting for each line item, which can be time-consuming and inefficient. To streamline this…
-
UX Enhancement: Red Font Toggle for Negative Numbers
In most cases, especially when adhering to accounting principles, it's preferred to display negative numbers in red font, similar to how Excel handles them. Currently, achieving this in Anaplan requires setting up conditional formatting for each line item, which can be time-consuming and inefficient. To streamline this…
-
Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
-
Call Center Functions: Agents must return whole number?
Is there any equivalent or trick to returning 'fractionalagents'? AGENTS(w, t, y, z) will always return a whole number. My stakeholders are interested in both whole/fractional agent calculations.
-
Five new Anaplan features you may not be using
Author: Misbah Ansari is a Certified Master Anaplanner, Anaplan Community Moderator & Community Boss, and CEO/Founder at Miz Logix. Anaplan has come a long way as part of its product development. We have seen so many features being released over the past few years which has not only helped Anaplan carve a place for itself…
-
Alternative of Rankcumulate
Is there an alternative to using RANKCUMULATE in Anaplan for cumulative ranking by group? The model's performance is impacted due to the use of rankcumulate. I'm looking for a more efficient approach or best practice to achieve cumulative ranking within groups without degrading performance.
-
Collapse / Expand Hierarchy Functionality in Modules and UX Grids
In current standard grid modules and UX Grids you can't Collapse & Expand hierarchies of Lists/Line Items/Sublist like you can do in Excel (see below). Considering that sometimes hierarchies can be huge or you want to Collapse one part but Expand another - it would be good to have such functionality
-
How do I show only those line items which have non zero values for list and time dimension?
I want to see only those line items which are not equal to zero from a hierarchy list subset in a module dimensioned by time as well. I am looking forward to create a line item which I will apply as a filter to the module. I have 15+ line items but the filter should only show those line items from the list subset for every…
-
How I Built It: Chess in Anaplan
Author: Waleed Hakim is a Sr. Anaplan consultant. Hi everyone! I’m Waleed — a Senior Consultant working with enterprise clients to transform their planning processes through Anaplan. I've been in the Anaplan ecosystem for just under four years now, and while most of my time is spent solving complex business problems, I’ve…
-
Data Hub Download for Level 2 Model Building Sprint 1
Hi Anaplan Gurus, I working on Level 2 Model building Sprint 1 training. There is process step where Solution Architect asks for downloading Data Hub Model in your anaplan workspace. There is link provided in the activity to download the data hub for sprint 1. On clicking the link, System lands me on the Anaplan Frontdoor…
-
New Module Experience - Modules Search Bar
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: It is not possible to search for modules in the new modules (Beta) experience. This is something that exists in the current one. How…
-
Ability to exclude zero values from AVERAGE calculation
A common requirement we see on customer implementations is to be able to calculate the average of a set of values but exclude zero values. For example if we have the following set of values (10,0,0,8,0), the average excluding zeros would be (10+8)/2 = 9. The current AVERAGE function cannot exclude zeroes and so gives an…
-
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
-
1.4.3.2 Import Data & Add Formula
Can someone help me figure out what formula I need here? All the columns are filled. What am I missing?
-
Display fiscal year label as FYXX/XX for cross year configuration
Hi, My company is using a fiscal year that is not aligned to the conventional Jan-Dec period hence it will cross over the calendar year. In the Time settings, we can choose to align the fiscal year label to start or end month but the format is still FYXX. However it will be clearer if we can use a format like FY22/23…
-
Improve Horizontal and Vertical Scroll Bar Visibility and Size for Enhanced Usability
Description: In the Anaplan UX, scroll bars—especially in grids and dashboards—can be difficult to see and interact with. The current scroll bars are thin and often blend into the background, making navigation cumbersome. Suggested Enhancement: Increase the default width of scroll bars across the platform. Improve contrast…
-
Poll: Should I have a single model or two separate models?
Hi Anaplanners, I am hoping to collect some feedbacks from you on an ongoing discussion I've been having with my stakeholders. My organization currently have 1 TQP model, which is focused on keep the model small and agile, and quick enough for about 200 managers to use to plan out their territories within a 5 weeks…
-
Unlock Your Next Level Model Building Potential with Improved Anaplan DX
Hi Anaplan Community! I’m excited to present you Improved Anaplan DX by valantic, a Chrome extension, that also works seamlessly on Edge. This tool is designed to make your Anaplan model building experience smoother, more efficient and supercharge your productivity. Download the Improved Anaplan DX today to bring your…
-
Level 2- Sprint 3- INV01 Question
Could anyone help me with the questions below? 1. My Beginning Inventory is not showing correctly with the effect of ending inventory, it shows the same number, please see the attached screenshot. My formula is IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning…
-
L1 Model Building 8.5.3 Activity: Import Data into Volume Inputs Module
Hi Everyone, Could someone please advise how to map this data in L1 MB activity 8.5.3. Please see the screenshot, I have tried time with Column header and then mapping time values manually in the time tab but it fails to map all values ( 36 values failed) Many thanks in advance.
-
Level 2 Sprint 2 2.3.10
Hi, as a result for the first question (2.3.10) I have the answer 71.34 but it should be 73.48. I don't seem to understand where I made a mistake. Could anyone help me out please? - DEM01 screenshot 1 (DEM01) - DEM02 screenshot 2 (DEM02) - DAT03 screenshot 3 (DAT03) - Formula: IF 'SYS01 Time Settings By Week'.'1st Forecast…
-
August 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our August 2025 official release notes. The information below offers supplemental information to that post. Planning experience Multi-browser tab syncing When changing context or data on a UX page, you can now view real-time data updates across up to five…
-
When deleting a formula from a module I would like the data in the module to also be deleted.
When deleting a formula from a module I would like the data to also be deleted/removed from the module. I realise the data can be removed manually by selecting the data in the module and pressing delete, but in a module with many thousands this is a time consuming process, particularly as Anaplan only allows deletion of…
-
Select Edit Cell data at Line item level on UX Settings
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: In Anaplan UX, when building grids or cards for end users, the current "Edit cell data" setting applies to the entire card. This…
-
Random number generator
Is there a way to generate random numbers from a defined range of numbers so that the numbers being changed regularly in a module every time we refresh the model or just run an action?
-
new module experience
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: It is not possible to export the modules view from the new modules experience. It is possible, but fiddly, to highlight and copy,…
-
Ability to select versions as a list formatted line item for use in lookup statements
Versions are useful as they allow switchover functionality enabling a user to both enter a forecast on a line and see actuals in the same line item. However, comparing versions to eachother (any version to any other version dynamically) requires a "Versions List" and logic to engage that list with the Version you want to…