Modeling

Formula
Hello, Quick question: How can I calculate the Volume between FY17 and F21 in the other module? For example, the difference between two years. Note: Just Volume is a line item. Please see the attached. Thanks, Mark
Behaviour of SEQUENTIAL parameter in RANK function
Hi All, We have a requirement to sequence items in a export and we've been using the RANK function to achieve that in a similar way that is listed in several posts in the community…
model performance
Hey People, Which option is better while applying a formula: 1 list (4 items) & 1 Line-item or 4 Line items? In terms of time-saving/performance.
New UX : Running a specified action or process following the list item creation via a form.
When creating a list item via a form on the Anaplan app page, I want to be able to run a specified action or process following the creation. For example, I would like to run an action that would set the attribute values of the list subset to TRUE at the same time as the item is added to the list via a form. For an item in…
Modeling with concurrent developers
Generally, modeling in Anaplan is straightforward when there is only one developer owning all the changes within a model. However, as your user base grows, so do the number of use cases and requests for enhancements. This means several developers may be developing functionality within the same Anaplan model concurrently.…
LEVEL 1 EXAM MODEL BUILDER ACTIVITY 5
Hello everybody. i´ve been stuck in this activity since yesterday, a create a Role list, With a top level of all roles, then i import the new data in the SY08 EMPLOYEE DETAILS with the extra role line and i don´t get any issue with the data. The thing is that when i try to change my formula for the BONUS, CAR COSTS, PHONE…
Profile Function for Revenue Recognition
Hi everyone, My company uses Anaplan for all budgeting and forecasting and we recently discovered an issues as this is only our second year. We have 2 metrics "Bookings" which are sales associated with contracted revenue, and "Installs" which are when the booking begins being recognized as revenue (as the product is…
POST formula in SPRINT 3
Hello, Can someone help me to understand why for "Confirm Purchase Order Receipt" line Item, "POST(IF NOT Submit Purchase Order Request? THEN 0 ELSE Final Shipment Amount, Final Shipping Time Weeks) " is not a correct answer for the formula to use? Regards
[Modeller Experience] Please, bring back the drop-down menu of open tabs
Please, bring back the drop-down selector on the top-right corner of the Anaplan view to display all open tabs at once. I personally find quite unpleasant having to go left and right constantly when I have a few tabs open. Excuse my poor sketching skills, I hope you all know what I mean.
Level 2 - Sprint 3 - 3.3.12
@Misbah Let me know if this is right?
3.2.11.3 Create Saved View for Combination Chart
The Product Replenishment User Experience page will include a combination chart of data from the INV01 Inventory Ordering module that displays the weekly data for the months selected with the Planning Period Filter. In the INV01 Inventory Ordering module, create a saved view: Saved View Name: Chart for UX * Include…
Level 2 - Sprint 3 - 3.4.3
The formula for Country Made in" is Parent(distribution center) I am getting an error, I need assistance
3.4.4 Activity: Create Stock Exceptions Review UX Page
Hello , I am working on Level 2 training and have been stuck on this activity. I am not able to set up page to sync as well as not able to set up SKU view from INV2 module. I would really appreciate support with this. Thanks, Alina
New Bee How to get Workspace
Hi All, I ma new Bee and little confused with the process to learn Anaplan. While activating account, I did apply for 90 day workspace and started the course for level 1 Modelling. The course steps asked me to confirm if I have workspace and admin privileges'. Not sure where to look for to see I have workspace allocation…
2.4.11.1 Create Product Family Manager Role
In the Supply Chain model, add a new role: Product Family Manager. Each Product Family Manager should be able to make changes to the Volume Growth Rates for only their assigned Product Family, but only view the data for the other three Product Families. The Product Family Manager role should be able to see the Detailed…
Restriction line item based on another line item
HI all, I have a module Fnem00, here we have to Select the Account and program. Based on that we have provided the DCA to enter the values in Fnem01. Now if I delete the Account and program in Fnem00 the Values in Fnem01 is Values are not getting erased. How can i fix this?
How to keep the input value after switchover
Hi All, i have a question about switchover Currently the forecast period is started from Jan 23 and i have input a $10 in this period however after i have switchover to Feb 23, the input value will gone. how can i resolve this issue? thanks Before switchover After switchover Blueprint
3.3.5.4 Update INV01 to Allow Override of Order Amount
@Misbah Can u let me know if its right? are my formulas right?
3.3.7.2 Add DCA to INV01 Inventory Ordering
Add Read and Write Access Drivers to INV01 Inventory Ordering module to set up Dynamic Cell Access to perform as shown in the example below: Week 1 & 2 (blue highlight) * Week 1 shows the result when Submit Purchase Order Request is NOT checked. * Week 2 shows the result when Submit Purchase Order Request is checked…
level 1 lesson 8.5.3 mapping
Unable to import file properly and map Could you please help me ...
Level 2 - Sprint 3 - 3.3.5.3
3.3.5.3 Check Your Work After you have added the line items and formulas for the INV01 module, compare your model with this example: Expected resultMy result Above are snapshots for the expected numbers and what I got after entering the formulas required. They are discrepancies, can anybody please let me knw what went…
Anaplan natural rollup is not equal to sum of values from its children
Hi, fellow Anaplaners I observed some weird behaviour of Anaplan natural rollup (meaning set line item as number & sum as summary method, then parent item will take sum of all its children's values). I have 2 line items here: 1. Commercial input is number formatted; no formula, is for planners to manual input forecast…
Improved Formula Editor/Bar
If the following features could be added to the formula bar in Anaplan it would make model building and maintenance a lot easier! * Colour coded statements and keywords (e.g. IF THEN ELSE, line items, constants) * Ability to indent and enter new lines. Particularly useful for IF statements * Keyword autocompletion *…
Activity 8.8.2
Hi, I am unable to add the right data in Fy 21 and FY 20 in the REP 01 Country Margin Report Module. I have added the exact formula as well but it is showing the correct answer in only the FY 19 rest two years are incorrect. I have check my other modules i.e., the referring module for this formula is also correct but the…
3.2.11.3 Create Saved View for Combination Chart
3.2.11.3 Create Saved View for Combination Chart The Product Replenishment User Experience page will include a combination chart of data from the INV01 Inventory Ordering module that displays the weekly data for the months selected with the Planning Period Filter. In the INV01 Inventory Ordering module, create a saved…
UX dashboard filter not defaulting to current user
In an attempt to reduce the size of a line item(used for dashboard filtering), we created a dummy list that contains a small subset of people. The subset of people has selective access enabled. I then used FINDITEM to link the Users list to the subset. The linking worked successfully. However I ran into an issue when I…
Will the Action work fine after renaming the list involved?
Has anyone faced this issues? Scenario: I have a list named "List A" and Source module "X" and "Y". Process followed: 1. I created an action "AC01" to import data from "X" to "Y" in Dev model. 2. Synced this action to test model. 3. If I run "AC01", it works fine. 4. Later remaned "List A" to "List B" in Dev model and…
7.2.3
I'm stuck trying to map this import. Below is an image of how I was trying to map it. If anyone knows how to map this correctly I would appreciate it.
3.2.11.3 Create Saved View for Combination Chart
3.2.11.3 Create Saved View for Combination Chart The Product Replenishment User Experience page will include a combination chart of data from the INV01 Inventory Ordering module that displays the weekly data for the months selected with the Planning Period Filter. In the INV01 Inventory Ordering module, create a saved…
Level 1 lesson 8.5.2 Mapping options
While doing this activity i faced issues while mapping it. But in my workspace there were an additional tab of time while i was mapping it. Could you please help me out to complete it correctly.

Upcoming Events

Save the Date: Anaplan Workflow - Next Steps in 2026
We’re continuing the conversation! Following the success of our first Anaplan Workflow event, we’re bringing you a deeper look at what’s next. Join us in March as we expand on the insights shared in the previous session and explore how Workflow continues to evolve to support planning collaboration and process efficiency.…
Community Challenge Recap: Annual rollover best practices
In this ACE Spotlight event, we will cover the most effective techniques for making your annual rollovers seamless and repeatable, based on the solutions from our latest Community Q&A Challenge.

Modeling

Discussion List