-
UX Table colours
Hello, I am trying to colour only some items from a table that I have put in the UX on a grid card. Any ideas? Idealy should look like this, only 2 iteams in purpule
-
Anaplan Last year values Summary(Formula)
I have two modules A, B. Module A has time ranges of Week, Month, Quarter, Year. Module B has time ranges of Month, Quarter, Year. What would be the best practice to get last year values from module A to Module B and have them reflected for Month, Quarter, Year? (I tried OFFSET, POST, but got error while changing summary…
-
Which is more efficient, TIMESUM( ) or [SELECT:Time.All Periods]
If I'm trying to accumulate all time periods from a source module with time dimension to a target module with no time dimension, which option is more efficient? Should I use TIMESUM with no start or end date, or a hard-coded select clause for all periods?
-
Anaplan error: Line item not recognized
Dear Community, I encountered an issue during the build of some of our projects and would appreciate further clarification if possible. Brief description of the case: I have two modules, A and B, that contain the same line item names "Adjustment" (module1.Adjustment, module2.Adjustment). When I tried using the same formula…
-
How to re-distribute or retain a value that is linked with a product, even product is deleted?
Hi there, I've situation where the Customer wants to keep the Overhead Values associated with a product, even though the product is being deleted from the hierarchy. I think of it as a manual entry for the value to be retained to that it can be re-distributed among the rest of the products or add to the total in the end. I…
-
Can any one tell me how to add categories and how categories defined?
Can anyone guide me on where to find the standard Category values for the Module Functional Area and List in Anaplan? Also, is it possible to change these options?
-
what Conditional formatting logic to be applied to only highlight highest valued cell and lowest
what Conditional formatting logic to be applied to only highlight highest valued cell and lowest valued cell in a given line item?
-
Graph time
Hello, I try to show on my UX graph only several weeks, but now, there are all the weeks shown and the graph is not lovely. Any tips?
-
Formula DCA to lock cell
Hello, I need some help with a DCA. So I have 3 line items weekly dimension : X (number), Y (number manually input) and Z Yes or No. So : If I select No on line Z, then line Y should be 0 (blank) If I select on line Z Yes and if line Y is not 0, then the line Y for that week (cell) should be locked If I select on line Z…
-
Referencing a line item that has formula summary method, not displaying correct number
Hello, In the example image, I am referencing a line item "TV Programming (Final)" in another module using an If statement IF XXXX THEN XXXX.'TV Programming (Final)' ELSE 0 However, it isn't pulling 4,063,964,538 as expected. I know its an issue with the summary method being set to formula because other line items are…
-
how can we decide the order of data while displaying them in grid in a reporting slide
so if I want to compare line item values for A,B,C,D,E but i select them in order of BCDAE for displaying in grid in the management reporting slide feature of Anaplan. How can that be worked out?
-
Previous list item in formula
Hello, Is there a way to assign a value depending on the previous list item? In my case, I need to assign the value 1 to the week 5, value 2 to the week 6 and so on until week 9. The values always go from 1 to 5, however the week number might change (for instance, choosing RFC24/01, value 1 is to be assigned to week1 ecc)…
-
3.3.5.2 Inventory Ordering Module Formulas
Why do I not see the values for 'beginning inventory' in my model?
-
Time Dimension & Value not adding correct
I have a model which has the time dimension (in days) and line items which are date formatted. I'm trying to create a chart which correctly replicated the progress of time change but for some reason any value is not mapping to the x axis of the chart. I have attached a picture for better understanding. In the picture you…
-
Revision tags with multiple builders
My client is asking what is the best way to allow multiple model builders in Anaplan independently? In the current system there is no way to isolate what changes should be moved to other environments, i.e., revision tags are cumulative. How do you all handle this?
-
Summing a line item with a formula summary method
Hi I have a module that is calculating correctly for each line item when I apply the Formula summary method as its based on the dimensions listed in the context selectors. I need to return the sum of this line item (highlighted in yellow) in another module but it obviously returns zero. I am sure I am missing something…
-
Formula Summary for reporting
Have to run a variance reporting for 3 Line items. In the source, the line items have dimensions and Time(Quarter). The variance Reporting module is run by the same dimensions, the source line items act as a dimension(by line-item subset) and looksup the Year selection by the user. The challenge is that one line item has…
-
Is it possible to colour input line items for ease of inputting. For eg as added in the screenshot.
Is it possible to colour input line items for ease of inputting. Also this colour should be present even before any data is inputted.
-
Need to know if we can take out some GB from 1 workspace and put that space into different workspace
Hi, I have a question where I want to split out like 30 GB from one of my workspace and put that 30 GB into different workspace. Current Situation Workspace 1= 130 GB Workspace 2= 300 GB Required Situation Workspace 1 = 160 GB Workspace 2= 270 GB If its possible how can we do this. Thanks
-
I NEED HELP ASAP
Hello, I need your help please!! I wanna import this file CSV in a list on Anaplan without edit the file. should i import the file in a module and create a code for each line then import the view in the list ? and how to do it ? thank you RGDS