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?
Hi, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a list…
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…
Why in my model output is blank, after send explainability data.
