I would like to use Dec of the following year as a lookup (example: this year is 2021, I would like to lookup revenue for Dec 2022). Is there a formula I can use to get the end of the calendar year mo…
Hi, I tried to import the PriceBook.csv, but when I try to map the data, the mapping tab shows complete different view than it should be. I guess the Modle REV 01 Price Book is correct. Probably somet…
Hi All, I am looking one of the use case to validating the history/previous value. Below is the use case: I have two modules (Module1 and Module2). Both are copy of each other. User will input the val…
I have created a saved view and named the view: as Forecast Periods The SYS00 Time Settings module has a line item for only the Forecast period. How to set Forecast Months only Filter? * Filter: Forec…
Before I reach out to Anaplan Support I just want to make sure that if it's only me or anybody else facing it. In New Modelling Experience (NMX) I am not able to see "Manage Models" Option. Misbah
Hi all, I'm stuck with the calculation of the bonus, car allowance,... by Role for more than 3 hours now. I get an error message referring to the G2 Country hierarchy, but G2 Country is not even in m…
I am not asking how to rename the Example model, that was done. I created a new level 1 model and named it but I want to follow the correct format shown in the Activity 1.5.2 which should be L1MB-my n…
Hi All, For 2.3.11.2 Create DEM03 Saved View for Global Demand Assumptions UX Module: DEM03 Demand Forecast Saved View Name: Global Assumptions Grid UX * Add a filter to this module to display Months …
I know I can't get answers, but I feel like everything should be correct in my formulas. However after I entered all of them, they just populated 0's. I've checked the source material it's pulling fro…
Hello everyone! I constantly face the problem that I described in this topic. The problem is that if, when loading data, you have time in the columns, and the rows have several non-embedded columns (r…
Hello, I find myself trying to refresh classic dashboard and backend modules with Alt+R, similar to the UX, and it would be great if we can get this functionality on the backend for module build.
Hi Anaplan, One of the things customers love about Anaplan is the easy-to-read formulas/ references that are visible through drill down or when modelling. However, the aggregation part of the formula …
Anaplanners, Quick question. I have two separate modules 1) Module 1..dimesnioned by only Project List with X number of Attributes as line items. 2) Module 2 Dimensioned by Project List and Time and l…
Hi, Trying to replicate this same Excel Formula in Anaplan, but leads into a Circular Reference. Please advise on how would do so. The Excel Formula and the Formula we are attempting to us in Anaplan …
Anaplanners, So I have a numbered list, which is used to populate project names by the end user. Projects are created in Anaplan by the end users, they provide name of the project and input various ot…
Currently, when a builder has Breakback turned on for a line item and selects "Select Levels to Show" in a module and only selects higher levels in a hierarchy, copy down/copy across will not work on …
Hi, Just wanted to confirm that does delete from list using selection works with respect to Selective Access? If the end user has full access of the model and not the admin access. If he runs the acti…
Unlike Classic, New UX doesn't have the option of allowing users to export the module/view from the dashboard directly without the pre defined actions. Idea is to provide the option to the end users s…
I created a module and process to delete all the data from Numbered list. it works fine to delete the data however there are some data (no parents, just code) which I am not sure how those got into th…
In a module, a line item is list formatted and the data displayed is in the form "String1:String2 Numerical code". How to truncate the data and display the string1 only in the same line item? Example:…
Can anyone tell me what these functions are for? I have read Anapedia but still having a hard time understanding what they do. MONTHVALUE HALFYEARVALUE QUARTERVALUE WEEKVALUE YEARVALUE In the sample b…
Question: In the Level 1 model, update the REV02 Volume Inputs Module to include a formula to pull data from the DATA02 SKU Volumes module Not getting what exactly i have to do in the attachment share…
I have a module that is dimensionalized by row ID (#1-#n), no parent member for that list. It is an input template to model new expenses. What I am aiming to do is to have another line item (could be …
* I am in Level 1, where as an 4.8.2 Activity I have to import data from Employees.csv into * E2 Employees# numbered list. But while importing it is showing Invalid parent. Please help. I am attaching…
Hi team, Currently, we have a few global programs in different business areas that unit numerous groups of users from different regions and countries. Mainly we use a global approach for each of count…
As a workspace admin, i need to build connected planning between models, meaning direct formulas references between models themselves. This is needed as our current only option is to either use import…
