-
Ability to see when another user has a UX Page open for editing
Since multiple model builders can (and do accidentally) end up opening the same page for editing, when one saves, and then the other saves, someone gets their work lost. It would be very helpful to have an indicator that shows up on a page that would shows me when if someone is already in editing mode on it. I imagine this…
-
Duplicate a Card on a page
There are times where it would be far quicker for the page builder to simply duplicate a configured card and tweak it (link, columns shown, image shown etc.) rather than create / use a card template or start a new card from scratch. I imagine this could be added to the little ellipsis menu for cards as a natural place. I…
-
"Missing" argument from "SUBSTITUTE" formula equivalent vs Excel
Anaplan's "SUBSTITUTE" formula has three arguments whereas excel's has a fourth optional argument that would allow for much simpler identification of specific substrings within a string that varies in construct: Anaplan = SUBSTITUTE(Text to search in, Text to find, Replacement text) Excel = SUBSTITUTE(Text to search in,…
-
Country System Module
Hi Team, I want to ask the Q that on what grounds is the mapping happening Like P3 SKU and G2 country should have the same dimensionality in accordance to Sum fn like we used the systems module to create a list formatted line item? can we do so in all the cases ?
-
Data not matching
This is the desired output the image below is one i got after completing inv01 inventory ordering i have error in 1. Ending inventory data for week3 and week 4 2. Shipping cost 3. Final shipping cost 4. Shipping cost variance Please help me
-
The Page shows the correct value but when drilled down it picks up a different value. Why is it so?
Hi Community, I have an issue where in the Page displays the correct value but as soon as I drill down it, it picks up a different value and shows a different result from that of the page. Is this an Anaplan defect?
-
Number of cells count conclusion exam
Hello everyone. I have successfully completed my module builder certification training. There was question during the exam that I was not able to resolve. This was related to the cell count for the export model to transfer the final demand from the supply chain model onto the FP&A model: This is the formula I used to pull…
-
Data error
the above image is in the lesson which we have to do This Thsi image The above image is what i have done after applying all formula and thus table matches the first table of first image but as soon as i made summary changes all value i get are wrong when i choose for the All products in page selector . The data i get is *
-
level2 3.3.5.2 Confirmed PO Delivery formulas
POST(PO Submitted, Shipping Time Weeks) worked in Confirmed PO Delivery Formula.OFFSET(PO Submitted, Shipping Time Weeks, 0) is right according to the hint in the module but it is giving wrong results as adding value in the current and 2 weeks ago column not filling the value in after two weeks.added a screenshot. Plz…
-
8 5 2 Activity L1 Model Build Import Data to Price Book Module
The Mapping Screen for the import looks different than what was shown in the lesson. I do not know how/where I have set up the module incorrectly so that I don't end up with the correct options for mapping the import. I have attached a screenshot of the (incorrect) mapping options I have - no tabs available. I also…
-
Issue When Using List Subset Picklist with a LISS
Hello, I've come across a scenario that appears to be a bug when combining Line Item Subsets and List Subsets. The scenario is that I have a report module that I created a LISS of. I then created an input module dimensioned by that LISS with a Line Item formatted by a list subset. The list subset is to only allow users to…
-
Lvl 2 Conclusion "Not available unless: You are a member of the Audience: Level 2 Sprints Complete"
Hi, I have completed all my sprints and sprint exams but my Level 2 Conclusion page still shows "Not available unless: You are a member of the Audience: Level 2 Sprints Completed". How do I complete it? My Sprint 2 exam shows as incomplete even though I have passed. Attaching all screenshots below.
-
Error in formula for override forecast and final forecast
-
Model Building Level 1 Model Building Activity 6 8 1
I have accomplished the activity; however, I have the word forecast appearing. Can someone help me? I need that to disappear. I am very new and would appreciate it very much if someone would guide me.
-
Use of default and mandatory "Organization" list in models
Has anyone used the "Organization" list models? Anaplan automatically creates it in every model which can't be deleted. I've never seen it used. I also don't recall any of the Anaplan courses use it. 1. Has anyone used it? If yes, how did you use it? 2. How is it theoretically supposed to be used? I guess theoretically,…
-
ACTIVITY 2.4.7.1
Hi Team, I have applied the conditional formatting as well as the formular but i keep getting 0 in my Forcast CF line item. Please asist to point me in the right direction of what I am missing.
-
Level 1 Model Building - Create SYS08 Employee Details System Module
In the Activities, the following is to be created: Below is the result: Is the result correct? Somehow I am doubting it when I started to import data. Regards Star
-
Need to breakback the value
Hi, I have a module with 5 products (A,B,C,D,E). all the products have some values with respect to 3 line items (X,Y,Z). Now i wanted to distribute the value of A in to the remaining products(B,C,D,E). with common percentage. Any idea how can i do it? Example here: A B C D E Before X 100 10 10 10 10 After X 0 35 35 35 35…
-
Suppress 0 or missing where there is no YearTotal aggregation
Hi I have a situation where I need to suppress 0 or missing for Headcount, Note that the Months do not aggregate to Year. The months are in columns. How do I achieve this, so that it look at Jan, feb, mar etc.. Thanks
-
Model Building Level 1 Model Building Activity 6 8 1
I am missing New York? Did I not input something in correctly. I have everything thing else there. Thank you, Katherine
-
Number to boolean format help
Hi team, Looking for help- i have a column with number format which shows currency value ( total) which takes FX rates into account as well . e.g $2,000,000 and so on... now i want to use filters which will give me projects having valuation more than 1,00,000 i created a boolean filter and tried to change the format for…
-
Identify Duplicates
Hi friends, Hoping to get some help with a method to help me finish up a labor calculation module. I'm tasked with allocating costs to contractors differently dependent on if there are multiple contractors from the same "Vendor" and "Area". IF multiple contractors from same Vendor in an Area THEN divide Area cost evenly by…
-
Update a filter based on picklist
I have a Module 1 with 2 dimensions. List A and List B. I have a line item in the module formatted as numbered List C which the users can select. I have a SYS module for List C. I would like to create a boolean in my SYS module that gets checked for any member of the list that a user selects in module 1
-
Ability to remove more than 1 user at a time
Anaplan only allows for 1 user to be deleted at a time. Recently, we realized 680 users were loaded into the wrong model, so I had to click "delete user" then mouse over to click "OK" 680 times...I'd like to be able to delete more than 1 user at a time.
-
2.4.2.2 Check your work
I used 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' formula in Baseline Forecast But in 2.4.2.2 work check FY21 is also filled.How can I fill FY21 in my module
-
QUICKLY IDENTIFY FILTERS USED IN DASHBOARDS
This has consistently taken me way more time than required. As a solutions architect, i need a quick way to identify which filters are being used in the UX. I am currently in the process of cleaning up 100s of filters built in systems modules and it is taking me additional time (and windows) to reconcile which filters are…
-
What is the best way to sort the list items
Hi All, In which way we can sort the list items names and suggest me in an optimized way which wont increase the model size. Thanks in advance!! Regards, Mahesh Kumar.
-
[Part 1] Validating user input in Anaplan: Approaches and challenges
Pros/cons of common approaches Common approaches: Examples Error logic User experience Example 1: Simple error messages Example 2a & 2b: Nested IF statement Example 3: Concatenation of multiple error messages Example 4: Separate errors for each line item Wrap-up of Part 1: Summary of common (sub-optimal) approaches…
-
How to Find Max for Specific line item
I am trying to create a module with the following line items (dimensioned by products in pages and line items in rows, time does not apply). when a product is select from pages: Max slots - display max value across any month When - display the month that the 'Max' appears Width Factor% - user input Width Interval - display…
-
Filters on the "Actions" tab
It would be nice to have the ability to sort and filter imports by source/target type.