Modeling

Combining Boolean value for some condition.
I Have Boolean line item for a module which consists of country and employee List as dimension. for another module having country as dimension and one boolean line item how can i check boolean line item as true if any one of the employee data for that particular country is true in source module(consists of employee and…
How to keep Filters active even after changing dimensions
Hi All, Hope everyone is doing safe during this pandemic. I'm trying to apply filters on time dimension on a standalone basis, but unable to do unless I bring in other dimension to columns. When I change the view I lose the time filter based on a line item in the same module - 'Current Year?'. Any reasons why Filters…
Organize Subsets when Changing Applies To Section in Blueprint mode
As a user, it would be nice to have the subsets indented under their parent lists when changing the applies to section in a module blueprint mode. This organization would mirror the same organization shown when adding dimensions in the initial module creation. This would decrease the time spent finding a subset, especially…
List order in column
Hi, Is it possible to display the summary first and then the list members for the list in column view? Thanks, Nisha. S
How to display names instead of numbered list
Hi kindly refer the following 3 screenshots: 1. A2 Account>Product# List 2. DAT02 PY Revenue to CY 3. Check Build Check Build is what I'm trying to get to but before doing so I need to figure the right dimension to use. I believe its the one showing in A2 Account>Product# List which is a combined list. But when I include…
Movement of Existing Modules to a new Model
Hi. Good Afternoon. We currently have a rather large Model that serves various areas of the business. Currently all payroll related items are visible and we would like to lift and shift these modules/lists to a new model and only pull through top end figures. This will remove the risk of people seeing sensitive data at…
Current Period vs Manually Input Period
I'm seeing some unexpected behavior in a Lookup formula that is referencing a period formatted line item. When I manually select a value for Current Year, my lookup formula performs as I expect it to. However, if I enter TIME.'Current Period' in Current Year, it shows the expected year in the line item, but my formula…
unable to find the format in drop down menu
Hi, for level 1, In 6.8.3 for module creation named SYS03 Country Details Module,I am unable to add the format List: G1 Region for the line item Region. Am I missing something? Please help.
Workspace ID and Model ID
Where can I find Workspace ID and Model ID?
Optimizer Pricing
Do anyone know about the cost and time it takes to enroll Optimizer functionality for a project
Property Definition in Line items
Hi, I want to be clear about the definitions of different properties of Lists. These properties are - Referenced in Applies To, Referenced as Format, Referenced in Formula, Next item index? Could you kindly explain? Thanks in advance. Regards, Sandip
New blueprint view (order of columns)
Hello All, Am I the only one surprised by the new blueprint view (the order of columns has changed) and not being able to find any info on Anaplan community?
Upcoming release User list calculations
Does anyone have any additional information on the upcoming release on 4/24 that will allow for calculations to be driven by the User list? This sounds very intriguing, so any intell would be greatly appreciated! https://community.anaplan.com/t5/Maintenance-Notifications/Upcoming-Maintenance-April-24-2021/ba-p/105343
Users list and Lookup
Hi Everyone, I have two modules A and B. The module A has one line item formated as a list "Users". Let's call it myUser. The module B's dimensionnality is Users (only). It has one boolean lineitem called myBool. I would like to retreive the value from B.myBool to A. I wanted to use the formula in module A.myBool =…
Dimension Mapping
Hi all, I have some data with various dimensions - one of which includes 'Colours'. I've also got a matrix between Colours and Cities separately (e.g. in the attached) which allocates Colours to Cities on a percentage basis. What I need to do is convert my data using the mapping to go from Colours to Cities. I'd normally…
Import Current Period
We would like the ability to import current period into the time setting. Currently, models need to be rolled over month by month. If we could automate this process, we would have less maintenance debt and be largely hands off as our models update.
Weighted Average in Summary of a line item
Hi - I have two line items, one specifying the weight and the other, say growth. For easy calculations, let's presume that the Weights and the Growth values are manual input. Growth is a manual input only at lower level - say a different line item is created for manual input. Now, when someone views the Growth at the upper…
Exam 3 - A 2019 Actuals
Hi, I successfully loaded the provided 2019 Actuals file and updated the Sales Planning model and I am still getting incorrect answers for the first 2 exam questions which are based on this file. I hit every check point in the Level 3 lesson sprints and successfully loaded the file, so I'm not sure why my numbers are off…
HELP with module setup
Hi hope someone can point me to the right direction. I have a module which Dimension by Agreement Number (xxx1, xxx2 etc) Timescale by month (Jan 19, Feb 19 etc) Line item :Start date : (when the agreement start) Feb16, Jan 17 Etc Line item Income : by the contract for every month I now need to show that data by: Timescale…
Calculation for a value to show every 10th of the month
Hi, We need help trying to write a formula for a value to show on only every 10th of a given month. Also need to consider that the weekends do not count and would fall into the next business day. For example 4/10/2021 is Saturday so would pick up 4/12/2021 instead.
Model Restore from History Logs
Are there any changes/items in model that cannot be restored from Model History Logs?
How to pick up the balance from a previous month
Hi, We are trying to pick up a Line Item Balance from the previous end of the month. For example, for the month of Feb, need to see the ending balance that is at the end of January.
Line Item Subset Summary Level, workaround needed please!
Hello, I have run into an issue for which I could not find any documented limitation or bug, but I think I may have hit one. I am looking for a solution to the following scenario: Let's say I have a constants module, ModuleA, that I am driving a LISS off of. Number1 Number2 Number3 Number4 = (Number1+Number2+Number3) Let's…
Finding the average
Hi, Need help creating a formula that pick's up the moving average for a number within 6 business days. Example) The amount for a line item over the past Weekdays were 1, 4, 6, 8, 9. I want to forecast this by finding the average of those days. Thank you
Import Transactional Data into DataHub
Dear Community, I have a question related to import transactional data (Net Sales) into Data Hub, with the following requirements: * The Net Sales and Qty Volumes are grouped by more than 10 attributes required for Sales Planning Purposes. Best practices in Anaplan is to concatenate those attributes that will be the key…
INV01 not matching up with numbers from CHECK YOUR WORK
Hi, My numbers are slightly off from the Example Model. (I believe like 2 units off). Attached is my Blue Print view and Grid View. Please advice. Thank you
Level 1 Exam - Activity 4 - Employee Drivers by Role - Data Import
Hi, Hope somebody can assist me please so I can progress further on the exam. I am completely stuck after exhausting all options this morning. I picked Column 2 Departments - map to E1 Departments I picked Column Headers - map to E3 Roles I picked Fixed line ltem - to map to EMP03 Employee Drivers by Role Line Items…
Power Function Error
POWER function is unable to calculate all equations correctly. Cube root of '-8' is '-2' But when I tried the "POWER(-8, 1 / 3)" calculation, it resulted as "NaN" (shown in Image)
Level 2 - Sprint 1 - 1.5.6.2 Import Data into Hist...
I am having trouble importing the Historic Volumes. I've tried every which way to map
FIRSTNONBLANK for Numbers
Can First Non Blank formula be used for numbers as mentioned. When i try to, i get an error as follows, Let me know if you are able to successfuly use this formula for numbers. Thanks Arun

Modeling

Discussion List