Modeling

L2 - S3 - 3.3.5.5
Want help with this formula.
Picklist of months: line item formatted as month
I have a line item formatted as Time then Month. The picklist only displays the individual months and not the total FY. Is there a trick to show the total FY too? I'm trying to avoid creating a list with the months and total FY.
Optimization in anaplan summary
HI All, Now i want to check summary of a line items wheather its required are not how can i do that. what is the possible ways to turn off the summary. Why cant we turnoff the summary of a dashboard line item.
Assign recipients via module in Notification designer UX - need to include people dynamically Role
is there anyway to include certain role people in notification alter via module dynamically??
Rankcumulate - unexpected result
Hi, I am using the rankcumulate function but I am getting some really unusual results, wondering if anyone could assist as I have no idea why this is occurring? I have attached the formulas and also the results. Thanks in advance
Moving values from one module to another while Line item is being used as Dimension in other
Hi everyone: Module 1: Dim - Entity (Aus 1, Aus 2....) LI - please refer below as (numbers) Module 2: Dimension: LI of first module , Parent of Entity (Aus..) Line item: Amount (which will have the values from the first module) I am getting same value distributed across all the Dim 2. Can someone help me out in this case…
Do saved views take increase model size?
Hi all, Do saved views take up space? If one module has 10 saved views vs. 1 saved view, does it make a difference on the model size? Thank you! Amy
Delete List Items Using Selection
Hi For deleting selected list items from the list by using "Delete List Items Using Selection" action, it is taking long time(nearly one and half to two minutes) as the list is having many list items nearly 14000 list items. It would be better if we find an alternative way to delete selected list items, such that it should…
"Error" message using Import to clear user input date data
Hello, Community In a daily replenishment planning model I've recently deployed for a customer, everyday, the planners may need to manually override below line items (format in brackets): ADS Values (number) ADS % Changes (%number) Cancel Order? (boolean) Manual Order Input (number) Override Delivery Date (date) Hence, I…
Retain selection of "Module" tab in Pages View
The new modules tab in the NMX "Pages" group is a great add. I've been using it to search in an entire app for a specific set of modules. I believe this will be a common use for this feature, which leads me to a small ask: The Issue: as a user clicks from one page to the next in the pages view, the selected tab reverts…
Find an item in chart with 3 conditions
Input Road 1 France Germany Type A Road 2 France Germany Type B Road 3 France Italy Type A Road 4 Italy Germany Type A Question Hello, I would like to know how to get back into a module the correct road. The road depends on three conditions as above. For example, if I am told that the road is France Germany Type B, I would…
11.3.4 Add formulas to profit & loss report module
Hi Community ! I keep getting an error on this last formula ... How can i fix this ?
Level 1 Model Builder: 13.9.3 Activity: Add Primary Grid to Volume Entry Page
The instructions tell me to enable editing however this is not an option to me as it is greyed out. Have I missed a setting somewhere back in the process?
Copy from one list member to another
I have an Input module by List:A,B,C,D The user wants to make the input for member A and copy them to all the other list members B,C and D so they don't have to make the i/ps multiple times. How can I do this ? If I have an import action then can I map 1 to many for the List?
[Part 2] Using line item subsets for dynamic error messages for user input validation
* Step 1: Create a module for your error messages * Step 2: Create your line item subset * Step 3: Create a System module to store metadata associated with the validations * Step 4: Create a module and use COLLECT to summarize error information * Step 5: Create an Output module to display the error messages and other…
Rank Formula || Need to Cumulate in Reverse order
Hi Everyone, I have a module dimensioned by List 1 and Time (Quarter). There is one imported line item (List formatted). I want to number these imported cells data according to the quarter. For example:- List item A has values in the following quarters Q1FY23, Q2FY23, Q4FY23, Q1FY24, Q3FY24 (other quarters are blank) so I…
User List in a Model
There should be a filtering option within the user tab so relevant filtering can be done on the user tab on the columns. This will help to manage licenses more efficiently and also user access.
Level 2 - Sprint 3 - 3.3.5.5
Are the attached values right?
Level 3 Sprint 2 - Account Exceptions UX instructions
Hi, I have created Accounts Exceptions UX Dashboard as required and data is in sync with what was in Level 3 - Sprint 2 - '4.5 Check your build' - (Screenshot attached) Further instructions are as below: After verifying the functionality of the Account Exceptions UX, use the Assign Action to update the Account to Territory…
Quick Sum Bar for Maximized Card Views in NUX
Hi, Quick sum currently works for cards on a board, but does not work when a card from that board is maximized. This was a feature in the old UX when a module on a dashboard was maximized. We have a good deal of users asking for this feature.
Rank Formula - Excluding Blanks
When looking at the page for the rank formula, there is a callout that says "Remember that if a source value is blank, the blank is ranked first for ascending order and last for descending order.". I am wondering how blanks could be excluded from a rank formula where I need to sequentially rank records based on when they…
How to find MAX number on a specific Dimension
Hello Experts, Need some help on a logic wherein I need to show Maximum number for a specific Dimension out of 5 Dimensions, for e.g. in the below screenshot I need to bring 49,258 from Line Item "A" (as highlighted) which is contributed by Tennessee (which is one of the States in States Dimension, on columns) on LI "MAX…
Filter feature for Module and Line item properties in Modules tab
Would be nice to have ability to filter by module properties in a model. This might be a useful feature for a builder team member to quickly analyze particular entities of the model. Since list of Modules, list of Line items, list of Actions/Imports and even list of Lists technically are spreadsheets themselves I think it…
L2 - SPRINT 3 - 3.3.5.3
My end result is not matching with the one showed in the activity (Reorder flag, Shipping time weeks), the others are probably right, but please check and let me know. Below are the snapshots attached regarding the query. Can anybody just go through this and let me know what's the error exactly. TIA.
Copying Anaplan models
Is there a provision to copy models created under one user ID to another ID? TIA, Varuna
Break text into new line
Hi Friends, What is the command required to break text into multiple lines in a Dashboard.
Move data from fake time period to real time period (For restriction of drop down selection on time)
Hi, I want to move the data from fake week to real week. I tried with multiple formulae and still getting errors. Request your help. Please find the screen shot of requirement below: And I have a mapping module as below: And my fake week list is as below: Note: The reason why I have created a fake time is period is that my…
Modeling in Anaplan with alternative tools: Part 3
Today we are thrilled to bring back one of our favorite Certified Master Anaplanners, Mitch Aist, in our Community series on how to model build in Anaplan with alternative tools. Mitch has shared his expertise earlier this year in Part 1 showcasing how to create a model and versions, and in Part 2, demonstrating how to…
LEVEL 2 - SPRINT 2 - 3.3.5.2
Can I know if the formulas are right and I need help with the other formulas
Adding a common line item associated with a single list item
Hello all, Can you please advice how to add "line item associated with a single list items"? In the attached screen shot, •MU approved/agreed and •GS approved are list items and I have created a nested dimension in module, such that the line item is common for these list items. Now I need to add, the columns highlighted in…

Modeling

Discussion List