-
[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…
-
2.3.10 Activity: Create Demand Forecast- Need Help
I'm not getting any values for my 3 line items after the baseline forecast. I cannot figure out why this is happening. I see growth percentages in my source modules, but they are not being carried over in my formula for my "DEM03 Demand Forecast Module".
-
Create DEM04 Demand Export Module
Hello, please help me define the summary methods of Demand Export Module to match my results with the correct answer from the course. here si my results The correct result is attached
-
Help with formula using IF THEN ELSE statement with Versions
Hi, I'm trying to create a formula where the End User Input will flow to both the Forecast and Budget Version of my model. The formula I'm trying to use is below. I can get the End User Input to show in my Forecast Version, but not my Budget Version. Thank you
-
Card Configuration - Not able to check "Completed?" Box
Hello Community, In both DEV and PROD models, I have a "Completed?" checkbox that will be able to lock a schedule. In DEV, I'm able to mark the checkbox but in PROD, the box is grayed out. I've checked the settings in the NUX page and they both have the exact same settings toggled. Would anyone have any suggestions on how…
-
Sync from DEV to Debug
Hello Anaplan Community, I've made changes to a cell in the DEV model, and I'm trying to sync those changes from DEV to Debug. When I attempt to do so, I receive the following error (see attachment) and it doesn't sync that change. Has anyone experience this before and have any possible solutions?
-
TAR01 Detailed Sales Targets
I am struggling with LI "Initial Account Sales Target" any hint please. Also could be please confirm rest line item is as expected.
-
Level 2 - Sprint 3 - 3.3.7.2
Can anybody let me know if the below attached screenshot is right with regarding its format?
-
Help on 8.5.3 import data volume inputs module
Below Im trying to map everything out. Im currently trying to complete the activity. I looked over the instructions this is my screen shot : But I have Volumes on the other tab The product code is not showing as an option just saying the word column.... @Akhtar.shahbaz Please and thank you 😄
-
DEM 03 Baseline forecast formulas
Hi, I am trying to write formulas for this activity: Here is what I am doing: But the results are nor correct, How should I change the formulas and/or summary methods? Thanks
-
8.2.2 Add volume input modules
My dates are not showing. It is only showing Jan Instead of the training screenshot . Its suppose to look like below: @Akhtar.shahbaz @ryan_kohn Please and Thank you
-
Level 2 Model Building (Sprint 1) - Activity 1.3.3
In the level 2 - 1.3.3 activity, am i importing the files correctly? For example, when i import the county flat list, the directions tell me not to appoint a parent. So I proceeded per my screenshot below. is this correct?
-
Put a condition in a lookup
Input: ABCDEFranceGermanySpainPortugalSweden Calculate : BCDEOrigin countryFrance (A)Germany (B)Spain (C)Portugal (D)Actual CountryGermany (B)Spain (C)Portugal (D)Sweden Hello, I would like to know if you can help me with the formula for "Origin Country". It is supposed to send me the information from the previous step to…
-
Boolean Selection
Hi, Is there a way where I can manipulate the boolean checked by the user and automatically selects as well the other selection? For this example, if a user selects Forecast-Aug, it will deselect the highlighted items for Plan, Actual CY and Actual PY as well. We don't want users to do multiple selection just to cover the…
-
Lesson 9.2.5
Hi all, I am trying to input the formula in unit price % in rev05. I am getting the error "Dimension of mapping used for lookup doesn't match any dimension of the result". However, when I input the formula in unit cost % in rev05 it works just fine. I have went back to look at SYS04 and SYS06 formats/formulas and haven't…