Modeling

Aggregation of Text Comments up a hierarchy using TEXTLIST
End goal is to be able to enter and aggregate text formatted comments up a hierarchy. Entry should be possible at each level, with prior results appended. I feel like I should be able to use TEXTLIST in the Summary: Formula for the line item and have it roll up the hierarchy on its own. I have not been able to figure out…
Circular Reference - IRR
Hi All, I've encountered Circular Reference in a calculation that involves IRR formula, for which I think is an illogical treatment of Anaplan. Please could you give some advice: The calculation is as following: Relation 1: Operating Results (ORt) = Operating Income (OIt) x Adjustment Factor (AFt) Relation 2: Adjustment…
Module Line item
Hi Would appreciate any help here I have a module ' Comp Reservation Details' which is mapped to the list 'comp_reservation_details'. I have entered the formula for the module line item 'Reservation ID' as ' comp_reservation_details.Reservation ID'. The values are getting populated in the column 'Reservation ID' as…
Conditional Formatting For Versions
Hey , I want to apply Conditional Formatting for one of the Version that is Variance not for line item so is it possible in anaplan ?? because we have only experienced to apply conditional Formatting on Line Items based on Values.
Change structure List
Hi Teams, I have data using List L3 but in next month(Feb 20) the structure will be change, but structure and data in previous month(Jan 20) not impact, like a picture bellow can we do that in anapan? Thank, Panji
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)…

Modeling

Discussion List