-
How to avoid showing disabled parent from Drop Down list Selection
User is not willing to see parents in drop down list selection. By creating a flat list of my level 4 and by creating mapping between L4 and flat list we can fulfill the ask but I am looking at multiple options on how to achieve this. Feel free to share the approaches if any.
-
Quarter Filter
How to create a user specific filter, where user selects a particular year, and only those quarters of year selected should be visible?
-
Create/Show Grand Total Column
Hi everyone, is there anyway i can create/show the grand total of all fiscal year in column time dimension? like if i have FY23,FY24,FY25 and FY26, then the next column is Grand Total. Thank you. Update: FY columns are from Time dimension and not item list.
-
Level Mismatch Error
Hello All, I am getting level mismatch error while set up the summary method as ratio, i am not able to set up the applied to and ratio as describe in the below ss simultaneously. what is the possible reason for the error and any ideas and suggestion would be appreciated, thank you for your help.
-
3.4.3 Activity: Create Country Summary Module (SYS08 SKU Details)
Having issue with SYS08 SKU Details "Country Made In" formula tried both formulas. I believe its because its a list that I am searching in but not sure best resolution would be ? Formula: 'SYS07 Distribution Center Details'.Country[LOOKUP:'SYS07 Distribution Center Details'.Country ] Error: The dimension of mapping used…
-
Faster method for SUM from multiple sources
Hi Everyone, Can anyone confirm which of the below is faster? Final Line Item = Module A. Line Item A [SUM: A, SUM: B, SUM:C] + Module B. Line Item B [SUM: A, SUM: B, SUM:C ] Line Item 1 = Module A. Line Item A [SUM: A, SUM: B, SUM:C] , Line Item 2 = Module B. Line Item B [SUM: A, SUM: B, SUM:C ] , Final Line Item = Line…
-
How to trigger a automatic mail notification?
Scenario: We have 3 modules, one with the source data, 2nd is the snapshot of module 1 and 3rd is to flag the variances between module1 and module2. If we are getting any checks in module 3, I want to trigger a mail to the Users about the checks. Is there a way to send a automated notification?
-
Dynamic Average Calculation
I want to create a functionality where the end user will select a start and end month from a pick list and based upon the difference in months Anaplan will calculate the average revenue. Revenue data is already available in the module in one of the line item. Can this be achieved through MOVINGSUM() ? If yes, how do it…
-
Users - built in top level not required
For a line item i need to apply ratio in summary and then in applies to select a general list. but it allows me to either do the ratio calculation or the applies to, when trying to apply both the things i get the below error "Count over Users hierarchy is not possible as Users does not have a built-in top level" I do not…
-
Month Number respective month.
I want a line item where I can select the month by drop-down. For this respective month I need the number value of the month. How can I achieve this.? Like October is 10. I am thinking to create a month flat list and use it, but how can I get the number? And i would very appreciate you if you share screenshot.
-
Re-order a general list alphabetically
Hi, I'm trying to re-order a general list into alphabetical order. Its a hierarchal list and I'm not sure what steps to take. The list is a dimension for many modules and performs as a drop down menu for UX pages. Any guidance on this would be appreciated! Thank you Joe
-
How to calculate Percent of Total in hierarchy and Put on a chart
I'd like to do two things here and would appreciate your help. I think I could do it with 15 steps but there has to be a better way. I've got a hierarchy called Workstreams with Products, Projects, and Unallocated that accumulates employees hours worked by month. In this module, W2 Workstream detail is the rows and then…
-
Add multiple list items to a List with subsets
Hello, Is there any possibility to add more list items to a Subset List and also be able to select the parent where the list item should be added? Currently I am using the Old UX and I use the "Create" Action where I can select the parent where I want to add the new item but the inconvenience here is that I cannot add more…
-
Browse new file when running import action.
Hi everyone. i created an import from CSV. now i want to publish this using page. my only concern is everytime i click the action/import. it wont let me browse to a new file. it only import to the old csv the i used to import when i created the action.
-
Modules with Different UID Dimensions
Hi ALL, I have three input modules, each with different UID dimensions: Module A → Dimension: X_UID Module B → Dimension: Y_UID Module C → Dimension: Z_UID (also includes a dropdown line item with two options: Product X and Product Y) Requirement: If a user selects Product X in Module C, the record should be stored in both…
-
Cannot refer to a line item in a different model
Hello everyone, Might be a very silly question. I am trying to refer to a line item in a different model but Anaplan is not doing it. Normally when I am in the editor or formula bar, I can go to different model and refer to a line item there. But between these particular models, I cannot do it. Its driving me crazy :-)…
-
Export module data specific to a page selected using an action
Hi Team, I want to create an action event through which I want to export specific page data to a CSV file. I have a page selector which has 3 pages. (version 1, version 2, and version 3) I want to export specific version data by passing the version number as input. Refer to the attached screens. How can I achieve it Any…
-
Selecting a month boolean line item then only month data should be displayed in other module
in Module i need to give 3 boolean line items named year ,month, quarter. in other module i need to have a line item named order amount . so the thing is if i select a year boolean line item in the first module then only year data should be displayed in other module where i have a order amount line item same for month and…
-
Workflow : Skip on Blank Assignees
Half a question and half a thought on the below toggle that I noticed has appeared recently Does this mean that you could setup a flow which was Task A - Task B - Task C where you could go directly into Task B if you weren't part of Task A? Or does Task A still need to be fully completed before going to Task B? And…
-
Filter list formatted line items based on list property
Hello All, I have a challenge where I need your expertise to achieve it. I have a system module for Resources where I have attribute called Employee Type (Permanent, Temporary). I have reporting module applied with Territory and BU. In this I have line items with Resource list formatted. I need to create a filter line item…