Modeling

Activity 1.5.2 (My question: How do I rename a new level 1 model?)
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 name.
L2 S2 2.3.11.2 Create DEM03 Saved View for Global Demand Assumptions UX
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 only. * Use Months as the columns and line items as rows. * Display only Baseline Forecast and Initial Demand Forecast line…
Exam Activity 6
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 from and it's all seeming accurate. Could someone help point me in a direction to troubleshoot the lack of data? Thanks!
Setting to ignore elements when imported into a time dimension.
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 (reference for the user, outgoing measurement (and the mapping is done according to an additional LI: code), then at the start…
Activity 3.1.4 Set time dimensions
Hey guys Do we save the settings after completing the steps on setting the time dimensions?
I want to add time as dimension in existing module
I have created module without time as dimension. Now how to add time as dimension in the existing module? Can anyone help me please?
Enable Hot Key Refresh for modules, etc.
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.
Toggle the Aggregation (e.g. SUM:) part of Formulas Off to Make for Easier Reading!
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 (while important) can sometimes make the formulas look more intimidating than they really are and much harder to read. It…
Publish with Time and non Time Line items
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 line items. Is there anyways that I can have a single a view, with Project names as row headers and Time along with non time…
Recreating Excel Formula in Anaplpan
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 are below. Excel Formula: =IF(AND(AJ31=0,AK31=0),AJ103*AK$71,IF(ISBLANK(AK31),AJ31*AK$71,AK31)) Anaplan Formula: Thank you
Dynamic List Name based on selection/input
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 other attributes pertaining to the project. However, I had a doubt on one new request, if the user selects a particular region…
Ability to Use Copy Down/Copy Across on a Higher-Level Breakback Cell
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 these summarized Breakback cells (Fig01). I would like the ability to use Copy Down/Copy Across in a module for on these…
Delete From List Using Selections works with respect to Selective Access?
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 action to delete items from a list for which criteria is set to delete all the items possibly of those as well to which he does…
Ability to Export Adhoc from NUX
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 so that they can export the data without running any pre defined export actions.
Delete data from Numbered List No parents
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 the list are still there(I believe because of the mapping eror). Also, on the delete module, these data dont show up but those…
How to Truncate the combination of string and numerical?
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: "ABCD:efgh 12345" (say) is displayed in the list formatted line item. Then, how to display only ABCD in the same line item?
What are these fiunctions for?: HALFYEARVALUE, QUARTERVALUE, WEEKVALUE, YEARVALUE
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 below, I guess that "each weekly sales" are compared to "average weekly sales." And it turns out to be "True" if a weekly…
level 1 exam activity 2
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 shared a screenshot of error
L2 Sprint 1 1.3.7.4 Create s G3 Location: Distribution Center? List Subset
Hi All, I created this subset. Should I add this as subset for G3 location list Please advise Thanks, Balarama Krishna
Totals (across a list) without a parent member
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 in a different module if needed) that will look to see if any of the rows have data. Essentially each row has line items…
Level 1 Importing data into list
* 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 picture
New UX - Pages Visibility Layer (by Roles and NewUX Pages)
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 county but still need minor customizations for them, so for end-users convenience we have to create customized pages based on the…
Time period check box
hi! When I tick a checkbox for a year, I want that month to be displayed in full. I think it's simple, but I can't do it. Please help me.
Ability to create Formulas between models
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 actions which need to be either run manually, or scheduled through cloudworks or would require a substantial amount of…
Serial Numbers in Anaplan
Hi All, I have a module with a subset of numbered list applied in its dimension. We want to derive the S.No/ Count of Items in the list in a line item in the module eg: If the list has 3 items A,B,C in the mentioned sequence itself then corresponding to A in the line item built we need 1 then corresponding to B we need 2…
Update List Property
Hi, I have been trying to update property in a list from a module with different dimension. Can anyone assist please?
ISACTUALVERSION - correct Output
Here's the official documentation on the formula - https://help.anaplan.com/138ee6b0-34a3-4654-b944-f655e6b28ad8-ISACTUALVERSION As per the article, ISACTUALVERSION returns TRUE for Actual Version and FALSE for all other Versions. However, I observed that the actual output is different when you use Time as a Dimension.…
Date Formats - Month Name/Text from Date
Hi, Does anyone know of a function that I can use to format a date in a specific manner. Bringing in month names instead of numbers. e.g. From 1/1/2014 I want 'Jan 14' as text In excel I would the text function - TEXT(*date*,"MMM YY") Thanks, Simon
Level 1 Activity 9.2.6 add formula to Margin calculation Module- Cost of Sales
Hi I am on learning level 1 activity 9.2.6 of Anaplan. I am struggling to insert the right formula for cost of sales formula as per training module is : Cost of Sales'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Cost * (1 + Unit Cost Growth %) All the other formulas are working well. I also tried to write the…
Conditional Formatting rule Inputted by user
Hi Guys, I just want to ask something. Now in the conditional formatting screen we have the range of MIN MID and MAX right as the basis for the color of the cells in Anaplan. Is there a way where the user will be the one to input the threshold (is the term we use in the model) or the MIN MID and MAX. in my example below I…

Modeling

Discussion List