-
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…
-
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.
-
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 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…
-
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…
-
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…
-
Rolling Forecast
Hi, can someone help me with modelling a 3month rolling forecast as per the attached picture? I can use a moving sum of the first 3 months for april but then for may, the formula needs to take the output of the movingsum of april and the actuals of feb and march and it is giving me a circular reference. Any ideas to solve…
-
Using Left for Different Number of Characters
I have account strings that are separated by a different number of characters for each string. I need to pull everything left of a colon ":" to get the first piece of the account strings. Some of the accounts are 3 characters and some are 4. Ex. AAA:BBB:CCC; AAAA:BBB:CCC. I need to pull all the A's for everything left of…
-
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
-
Anaplan Color Pallet
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: The Anaplan Color pallet should be consistent across all forms. Text Pallet is different Action Icon Default Colors, and different…
-
How to create Anaplan formula MTD with Input Date
Hi, I'm trying to create a month to date line that is based on a specific input date, not the actual date. Is this possible?
-
How to set a unique code based on Store/date information ?
Hi everyone, Does anyone know how I can generate a unique code by Store/date combination, knowing that the date is a current date that will be changing every day, it's going to be the order ID and and it going to have to start by a #: Thank you for the help :)