Modeling

2.4.7.1 Create Demand Forecast Grid UX saved view Not formatting
I entered and cross checked my data inputs and formulas. The conditional formatting is not functioning. Please help
Calculation of modules & Size....
Hi Everyone, Can anyone help me to understand, how we are calculating the module size in GB format? If I want to see the actual size of my modules in GB then, do i need to enable any option in Anaplan. Regards,,, ___________________________________________________________________________________________
Stuck inside a subsidiary view
Hi All, On a number of occasions when reviewing subsidiary views I have found that I am not able to return to the default view. Despite, selecting 'default view' from the tool bar I am forwarded back into the blueprint. The only remedy I have found that gets me back to the default view when this occurs is to close the…
In the drill down window being able to filter on values for non blank or non than zero
Hi Anaplan, It would be amazing if within the drill down view you were able to filter on a list of values for items that are non blank or non zero. So for example if you're looking at a calculation with a dimension that has 1000 items you can see only the relevant items with non zero or non blank values that contributing…
How to get the Index of a Numbered List Item ?
Hi guys as the subject, I want to get the Index of a Numbered List Item, what attribute/property should I use? the Propeties I've tried: (Item )Index (Item )ID (Item )Number (Item )suffix by the way, what is the data type of the index? Thank you~
2.4.11 Activity: Create Roles and Test as End Users
Hello! Would love some guidance here. Roles were already created And for Product Family Manager I have Write access for DEM01 but not sure how to navigate the rest.
CUMULATE circular reference
Hello, There are similar posts on this topic, but none of the solutions seem to work. I am trying to create an inventory calculation that allows the user to delay/push production to subsequent periods. Then, the total production that has been pushed will be produced at one time. CUMULATE is currently used to aggregate the…
Collapse Saved Views in Contents Panel
Add the ability to collapse saved views in the contents panel similar to how you are able to collapse functional areas. If every module has a few saved views the contents panel becomes hard to navigate.
New UX - Initial Page?
Hi, I'm building out some dashboards in the New UX -- in the classic view, you can set "initial pages" on page selectors so that it default opens to a specific month/department/etc. In the new ux, this doesn't seem to be a feature. I need to be able to show a specific view on many of my dashboards. Is there something I'm…
NMX - Make it easier to enter edit mode when opening the new formula editor
Now that the New Modeling Experience (NMX) has launched the 'preview mode' functionality whilst working with a formula, users have to explicitly click the 'Edit' button to be able to edit the formula. This idea is requesting the ability to enter edit mode more quickly with the new formula editor open in preview mode (for…
Summing of list items to another list item in the same list
Hi There is a requirement that we need to sum list items total to a specific list item in the same list based on some selections User selects Yes/no one line item(drop down) and Revenue method on another line item(drop down) Lis items which are having Yes should be summed to the % revenue method list item attached…
Report Builder Left Panel should be adjustable
The left panel that designates the slides in the Report Builder should be adjustable. We can fit ~28 characters in the panel which makes it difficult to write titles for multiple slides. There is a lot of white space between the chart and the left panel on a full HD monitor meaning there would not be any impact to the…
Different switchover dates for financial statements in same model
Hello, I am brand new to Anaplan and am building a long range plan that has P&L, BS, CF. Our actual version in AP for the P&L is an import from our accounting software that is actuals + forecast = total FY year. For example, our FY year ends 6/30 so if I am in Dec, i will load a file that is 6 months actuals and 6 months…
display name not referencing module line item
Hi: Any help would be appreciable. I have numbered list and has property display name. It has formula to reference from one of the module. However it is not displaying anything on that display name property section even after I set display name property. Is there anything I am missing? Thank you
How to connect a long list of vendors with multiple other lists
Does anyone have experience creating a module with a long list of vendors (4000+) by multiple dimensions (market, department, legal entity, business unit) without breaking their module? Currently we are only able to show by one dimension but we really need it by all four, would greatly appreciate any insights on how to…
Anaplan put to rest mode after 60mins
Hi, May I know the reason why Anaplan model put to rest after 60mins ? When another user tries to login again, it takes time before the model re-open. Thanks in advance for helping, Tom
Model
i want to learn level 3 can u please share link of the course with me . i am not able find that course
Last day of month for line item
Hi, How do I get the last day of the month for a given line item when the module is dimensioned by Time? Please help. I need the last day of the month for the line item in the screen shot.
Comparing text formatted line items
Hi Team I am having a module with two line items(Error 1, Error 2). I need boolean to be checked if the texts in two line items are not same and it should retrieve the text which is not same in another line item. ListError 1Error 2BooleanOutputProduct 1Text 1,Text 4Text 1,Text 4FALSE Product 2Text 1,Text 4Text 4,Text…
Be able to execute an action as admin
It would be useful to define some action to be executed with "admin priviledges". For example to clear, with an action, some DCA dependent line items that are no longer writable.
Issue with formula editor getting worse
Hello All, A couple of months ago I called out an issue (confirmed to be a known issue by Anaplan support) about the formula editor in the new modeling experience. You could not reference a list item by clicking, you had to type the entire reference.…
Timesum with Date
Hi I want to use Timesum function. In this page, we can use Timesum function with end date to start date. https://community.anaplan.com/t5/Idea-Exchange/Dates-in-Timesum/idi-p/89565 But in Anapedia page, it is not suggested to use Date. https://help.anaplan.com/13d8b551-4e13-413b-a39f-f25579d21e38-TIMESUM Is there some…
2.3.9.1 Import data into DAT03 Historic Volumes module
When i am running the process as described * Run Process 9 Import Data from the Hub. I am getting error as Any help will be appreciated.
How to pull property data in line item
Hi, I have module with two lists and in that module for one line item i need to pull data from one of the List's property. for example: i have Employee list with its property as "Position" and i have module with Employee & Product as List and i have Line item as Position. So i need to pull Position of all employees in that…
Help needed: formula is invalid
Hi, My name is Usha Priya. I am trying to add formulas to the SYS01 Time Settings by Year System module. I get a message saying the formula is invalid. Please find below the screenshot. I need some help to solve this issue. Thanks.
Prevent Future Date Selection
Hello! I'm building a model where users can input the dates when they complete certain training events, and then taking that information and creating visualizations/analytics off of it. In order to keep the data clean, is there a way to prevent the user from selecting a date in the future since I only want to deal with…
Formula to get code of a parent
Hi, What formula can be used to get the code of a parent list inside a flat module? for example in this particular module the parent is a numbered list and I want to bring its code in the 'Code' line item( Text Format). What method can I adopt to achieve the same? Thanks
Sprint 2 Activity 2.3.9.1
I’m really stumped here on this activity and can figure out where I went wrong. Could someone assist.
2.3.10 Activity: Create Demand Forecast
As per the below activity information provided, do we need to write the formulas for all the line items in the module or need to write the formula for only Growth Rate % line item? Can anyone provide clarity on this activity for me?
REQUEST: setting to always show the Formula Edit bar when in blueprint
Allow the MB to turn the Formula Preview Mode ON for all Blueprint views. This would be a persistent toggle. So anytime you switch to BV you would see this at the bottom.

Modeling

Discussion List