Hi All,
I have a module with customised timescale. In Module A, dimensioned 24 Week Custom Timescale. In Module B with no dimension, I would like to get Sum of 12 Weeks from Module A. Any leads, please?
Thanks.
I would use a lookup.
Module 1 has your line with Data in it. You can add a line to Cumulate across your custom time list.
Formula could look like this: CUMULATE(Data,FALSE,Custom Time Scale List)
'
In this case we want to get the number from month 12 it sounds like, so I would create a selector that would allow us to define month 12. This selector would make sense in a SYS module, however, in this mockup I just included it in the same grid. Then Lookup this number using a formula like this: 'Module 1'.Cumulate[LOOKUP: Month to Lookup]
As you can see I have my sum from the first 12 now displayed in a module that is not dimensionalized by our custom time scale.
Jason
This works! Thanks
@jasonblinn In case if I would need to get moving average then the lookup is working for Particular Week. Example :
I tried using lookup Current Period -1 but somewhere I'm lost. Can you help with this?
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.…
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…
