Modeling

Line Item Switchover - Formula Error
Hi Team, I'm receiving a Formula error when I turn off the Switchover on a particular line item & I can't understand what is driving the error The error occurs when I turn the Switchover to FALSE in the Calculation image below Any ideas what would be driving this? Error Calculation Reference 1 Reference 2
Missed the Anaplan Live!: Anaplan Helps Q&A?
Did you miss our first Anaplan Live! Spotlight event? The recording of the live discussion is posted here! In the live event, our presenters discussed all things Anaplan Helps! Watch the video to learn how the program is helping support customers during this challenging time and hear from MAs about the applications they…
easier way for data entry validation and dependent/filtered lists
Noticed this when trying to create an end user model and wanting to only allow valid data entry.... While there is a way to create dependent filters for lists in modules, in reality it is not intuitive and (in all likelihood) too time consuming for most users to attempt. Especially with several dimensions this adds a lot…
Add Test model to existing ALM
Good morning everyone, We are currently in the process of adding a test environment in one of our Workspaces. The target model is already deployed, and an ALM between the development model and the production model is already in place. However, we cannot simply duplicate our production model and integrate it into the ALM as…
How to use SUM function between modules
Hi everyone. I have a simple question. I would like to calculate the total cost of staff from a module that inputs the cost of staff for each month. Please see belows... How can I solve it? I don't know better idea... Best regards. Taku
Level 2
Hi, why my line chart on Dem 03 shows Baseline Forecast and Initial Demand Forecast for one year. I have used the formula for Baseline Forecast: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE OFFSET(Default Forecast, -52, 0)
Formula Inquiry
Hi Guys, I just want to ask something. Our client has an excel report template, its more like Operating Statistics type of report. It basically counts values per month and it is usually referenced to another cell in their report. After checking the issue sent to us I notice one 1 line item (actually it is an entire year)…
Bring weekly data into a daily module
this should be easy but I just can't get it. I have a weekly module with inventory cases...snapshot is done on Wednesdays. Anyway trying to take that snapshot and have it show up in a daily module on the Wednesday date. Any help would be greatly appreciated. I'm trying to avoid making the inventory cases a daily module.…
Planual Explained - Day 15
"Rule 2.02-03": Article 2, Chapter 2, and Rule 3 – “No Repeated Expressions”. “If the expression is repeated in the formula (or other modules), put it on a separate line item. Calculate once, reference many times. It goes against PERFORMANCE, NECESSARY elements of PLANS if you wish to go against this rule Here is how it…
Version formula
Hi! It would be great if version formula feature would be applicable not only to line item subsets but also to ordinary formats as in case of large number of versions and difference between approaches used in each of the version it will save a lot of time and enable more flexible modelling.
How to Apply Time Filter to graphs?
How can we apply Time filters to graphs?
Planning Sales or Invoices Using Tier Pricing
Summary As an ad planner, sales representative, or merchandise planner, you might be interested in planning your sales or invoices using tier pricing. This solution will address a user story that allows you to set the prices by tier range and automatically look up the right price based on the units ordered. This solution…
Level 2 Model Building Sprint 3 INV04
Hi, Could someone please help me with the module below? I am struggling with the Percentage Full result that I get and I think it is because I am doing something wrong in the Beginning Inventory line. I am pulling BI from DAT01 which gives a straight line across all months. What am I doing wrong? I also could use a…
Error in Importing
Hi, guys! I always have this problem when I am importing my data in Anaplan. I tried all the methods I know but I can't solve this problem. I am trying to upload this data to my budget version but to no avail. Hope you can give some assistance! Thank you for the help!
Import Fail - Invalid date or Timescale error
Hi Team, I have a line item where the data is Imported from another module in the model I have also created another line item in the same module which is set to No Data that I Import to the line item mentioned above to clear it before running the previously mentioned import action. I have these 2 Actions in a process (1st…
How to implement "hardcoded" logic with best practice in following example
Hi, I have the following challenge in modeling the target module. I need to aggregate data before calculation to account level 1, but there is an exception for certain accounts where I need to aggregate those for level 2. I have tried to create system account details where I flag those accounts which are exceptional…
How to rename the Time from Week 1 FY 20 1-Jan-2020 to 7-jan-2020
Hi Guys, Is there a possibility to rename the TimeScale from Week1 Fy20 to 1-Jan-2020 to 7-Jan-2020 Thanks and regards PJ
Transformation Data
What is "Transformation Data" in Anaplan ? What is its significance and in what scenarios, it can be applicable ?
Planual Explained - Day 14
"Rule 2.01-15": Article 2, Chapter 1, and Rule 15 – “Filters in separate modules”. ” Try and keep filters in separate System modules. They can then be reused for different modules. In the notes section list where this filter is used to prevent accidental deletion”. It goes against Auditable & Necessary elements of PLANS if…
improving filters and tags in manage model page and Anaplan UI
I am posting this on behalf of Jason First, design a way for our model builders to tag their models with attributes like Model Owner, Model Purpose Category, or other built in attributes like Environment (as in Picture 2 below). Second, design a way to filter or sort models based on these tags in the Model Management pane…
NUX or Old - Add Jump to Section (Text Object) Functionality
As a user, it would be nice to add a jump to section functionality on either the pages in the NUX or the dashboards of the old UX. Some dashboards can be quite lengthy and scrolling becomes difficult when you have to navigate your mouse into the white space (as you scroll down) to avoid any published module views that…
Query on Parent function
Hi Guys, Curious - Why wont we use Parent(Item('G2 Country')) for line item 3 (Region)? Thanks
Move "Refresh" button from Edit Menu, onto Main Blueprint Toolbar
This is a quick one, but I was wondering if we could move the Refresh button out of the Edit Menu and into the main module blueprint toolbar? When I explain it to new folks, they always find it un-intuitive to have to open the Edit Menu, before they can Refresh.
Planual Explained - Day 12
"Rule 2.01-14": Article 2, Chapter 1, and Rule 14 – “Avoid using Select Levels and Filters together”. Don't use Select levels combined with filters on the same hierarchy. It is a double filter and inefficient. Use one or the other. Setting a Boolean line item in a System module with 'none' as the summary option will often…
Anaplan Foundation Model
As the Anaplan App Hub is currently undergoing a redesign and upgrade, this post will serve as the formal documentation source for the Anaplan Foundation Model. Anaplan Foundation Model Download Process: 1. Click on the link below to begin the download * (Old Link)…
How to cross-join 2 lists
Hi Anaplanners, I am Simon from DXC. I am working for a requirement which needs to generate a cross-join list based on 2 lists. But I doubt if Anaplan can do this like SQL queries. I would like to take any workaround as well. We have 2 lists: one is for Managment Nodes and another for Industry. In Management Nodes there…
Variance Calculations and QTD Formula
Hello, I’m working on developing a Variance Analysis Module. I have reviewed the posts on Community and found this training that has been helpful. I used the below link to develop the Comparison and Variance Modules:…
Allow Format & Style Selection While Adding Line Items
As a user, it would be nice to have the ability to choose the format, style and add notes while adding a line item. I imagine format and style are the most adjusted settings for a line item and notes are at the very far right of the blueprint screen which adds time and decreases likelihood of builder adding them. I will…
Rollback caused by "Is Summary"
Description of the enhancement: When a user incorrectly selects "is summary" for any line item with non simple formulas they hit a rollback. A rollback consists of a model closing, opening, reapplying a changelog, and saving. Can we look into a solution to capture that the formula isn't a summary line item before it causes…
Copy Existing List Button
As an author of a new idea, I want to have the ability to copy an existing list to save a new version of the list. Lists can often be similar in structure and/or list members and it would helpful to have a copy list button. I'll know this is successful when I'm able to go to the general lists page, select a list and hit a…

Modeling

Discussion List