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?
There was an error rendering this rich post.
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
