I am currently trying to calculate rate of leave taken of prior periods and compare it against corresponding months across different years. I was wondering if someone knows of a function or formula th…
Hi team. I really need help with formula to determine the numbering of the week in month according to given start and end date. I have a module with daily rationing coefficients (they add up to 1 per …
Hi, I have a module Target Setting with 3 dimensions: Brand, Category, Time. Users make an % input to indicate how much each combination should increase Revenue for the next Year. Then, the Target SKU…
Hello, I am having a hard time trying to make a formula work in a summary output module: The dimensions are: time, r&d cost voice (list items: reticles, moves, licenses, services, labor, depreciation,…
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
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…
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 e…
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…
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 fo…
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?
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…
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…
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?
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 …
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 a…
