Modeling

Need help avoiding Circular Reference Error while using POST formula
I am working with a system that calculates what payments should be, then when the actual payment is made we record what that value and save it back into the model. Sometimes there are retroactive changes, which cause a variance between the calculated and the actual amount. We want to be able to post the variance to a…
9.2.6 Activity: Unable to input data in a module
Hi Team, I'm trying to make the cells input ready as these are being referenced in a lookup. But they are greyed out and I'm unable to change it. Please help.
OEG Best Practice: Inside the Hyperblock
What are blocks? How blocks are calculated – General Lists How blocks are calculated – Native Time/Native Versions Hyperblock performance Summary block counts Should I worry about blocks? A reason why we shouldn’t focus on just the block count Focus Points We recommend this article to Experienced Model Builders and…
How to know current User ID
Hi, I am trying to create a DCA where in the requestor should be the only one to be able to Submit a request. In this example for this module, I am logged in as user id Camille@abc.com. since the requestor is Mark@abc.com, the Submit checkbox should be disabled since me(Camille) is not the requestor. Is there a way to do…
breakback when using average in the summary
Hi everyone, When building a model, I came across the need to do breakback with an average as summary method, but I found that this option is unavailable. Basically, what I wanted was to be able to adjust the values month by month and see the influence that it has on the average of the full year and also be able to adjust…
Identifying REAL First/Last Month Monday Dates
Hello everyone, Please see the picture enclosed. I am trying to get Anaplan to identify the first and last Monday-dates of a given month, but I keep getting the wrong results due to the native calendar setup. Can anyone help me with a workaround? Maybe through convertering it into text and then into values and then setting…
Filter to show only list items with a monthly value?
Hi! I have a P&L based on a list of accounts (rows) and months and FY (columns) where I want to show only accounts which have a value <> 0 in any of the months in current time period. Today this is solved by a filter in the P&L to show only accounts with a value <> 0 for FY21 OR FY22 OR FY23 (model holds those three…
Error : Time Filter to two dimension (Time*Lineitem)
Hi, I want to filter this table by Time in UX. The point is this table has two dimension(Time and Lineitems) in columns. Table A I prepare Time Filter Lineitem dimensioned by time(Quarter and Users) After I filtered Columns(Time,Lineitems) in UX, but I can't see any Time and Lineitems. Table A (Filtered) If I filtered to…
Add or Adjust Time Dimension On An App Page
I have a schedule that is populating Q3 numbers, even though we are only in Q2. After doing more research, I believe it relates to there not being a time dimension on this page. Can anyone provide guidance on how I would be able to add or adjust the time dimension so that only prior and current quarters are populating? For…
Community perspective: Add a timestamp to processes utilizing Anaplan API and Python
Anaplan is a critical tool for different business processes, and it is used to handle a variety of data. One key attribute for data quality is the timeliness and reliability of the data. It is a known best practice to use Data Hub for centralized data management and then import data to different spoke models. Even though…
IF Then Else Issue
I want the Repair and replacement = Flat terminal then 1 else o (or) True else false No getting the result
Calculate classic month summaries in week model
Hello, I have a model set with a week 4-4-5 model calendar. In this model I created a module where I input the team presence per day. My issue is that I would like to calcule number of days worked per month, I mean from the 1st to the 30th and not by week as it sums up days from prior months (see image). On the image,…
Making the same Line Item both Editable and Formula Driven
Hi, I was wondering if there is a way to make the same LI editable and formula-driven at the same time. Assume that I have a module with a dimension D and line item L. Now the Line Item L is a list formatted dropdown of list P. P is a property of dimension D, which is defined for certain items of list D but not all (say…
level 1 lesson 14.4.2
why my line chart is showing a straight line only? it should be like this.
level1 lesson 14.6.1
how to change the product list to pages. it is showing in Row
IF then Else issue
I am Having two list formated line item, NOw i want chek true or 1 base on the one list item to other list item how can i acheive that
add a role list
how to add a role list in the model
exam 1 activity 6
why my region row is blank
exam level 1
stuck in Activity 2 i am stuck here please help
Parent hierarchy & Top level
Hello fellow Anaplanners, I have a query, I was going through an existing model and where I saw there are multiple composite hierarchy built having just 2 lists. i.e one is parent list (say 'X') and another is child list (say 'Y'). Now here in first list 'X' (which is parent for the other) there is only 1 member 'All X…
Ability to import a table from a report page to a board or worksheet
Hi everyone, I was wondering if it is possible or if anyone knows how to move a table from a report page to board or a worksheet. In this specific case I had to use a report page in order to use the "variance in report pages" functionality which does not exist neither in board or worksheet pages. This is what I have…
Statistical forecasting App in UX
Hi all, I can see that there's a statistical forecasting App on the App Hub that can be downloaded but it looks like everything is in Classic dashboards. Does anyone know if there's a version of the app that uses the UX? Thanks
Add columns to modules with differences and ratios and between years
Hi everyone, I have I doubt which is if it is possible to add a column or more to a certain module in order to know for example the difference between the revenues in FY20 and F21 or a ratio that shows how much it grew from one year to the other. In this specific example I want to create something as can be seen bellow…
Compare TEXT Values in Anaplan
Technical Summary Statement The objective of this article is to compare values in a TEXT formatted line item and identify the values that occur more than once (duplicates). Problem Statement Sneakerz is an up-and-coming shoe company with a variety of shoe brands in its brand portfolio. They are expanding internationally…
Lookup Sales Based on drop down list
Hi, I need to retrieve the historical sales based on the selected Store from dropdown list of my module. Here in Module 1, the Store List has no sales for specific SKU that is why we're going to get the sales from the similar store. Module 1 Dimension : SKU, Store List, Time (Line Items: For Expansion?, Similar Store…
Add columns to modules with differences and ratios and between years
Hi everyone, I have I doubt which is if it is possible to add a column or more to a certain module in order to know for example the difference between the revenues in FY20 and F21 or a ratio that shows how much it grew from one year to the other. In this specific example I want to create something as can be seen bellow…
Reset boolean when selecting a new hierarchy in UX
Hi all, Hope someone can help me I have a 2 grids connected and set with restrictive access, What happens: First: When I select the country (1st card) to be updated on the graph (2nd card). The selection is kept when I change region. Example: US-Chicago Second: But if I change region to Europe, the Chicago previous…
LEVEL 2 SPRINT 3 INV01 3.3.7.2
@JaredDolich I am at the point where I have added DCA to INV01 and added formulas to AD02. My numbers do not match the example given. I know in the past I've been told not to worry about the numbers being off but is that the case with this example? Here are my numbers: Thank you for your help.
View access based on User list
Hi, I have a module where users create New Cost lines. Since the security is based on Groups, users can see costs created by other users within the group. Now the ask is that users should see the costs created only by them, for example, User A would see cost items created only by A, B should see only B's lines etc. Note…
Pulling value from another line item in the same module
Hi I have an Emp List. An employee can have 2 records in the list (the 2nd one with an extension ABC OR). I need to pull the values of the 2nd record in another line item of the 1st record. Could you please suggest how to show the values in Red below? Thanks Is ABC OR?Projected salesABC OR SalesJohn DoeY1000520John Doe ABC…

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