Customised Time Scale

aishabhy05
aishabhy05
in Modeling

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.

Tagged:

Best Answer

  • jasonblinn
    jasonblinn
    Answer ✓

    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)

     

    jasonblinn_0-1592879050402.png'

     

    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]

    jasonblinn_1-1592879149046.png

     

    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

     

Answers

  • aishabhy05
    aishabhy05

    This works! Thanks

  • aishabhy05
    aishabhy05

    @jasonblinn  In case if I would need to get moving average then the lookup is working for Particular Week. Example :

    aishabhy05_0-1593521041380.png

    I tried using lookup Current Period -1 but somewhere I'm lost. Can you help with this?

     

    Thanks.

Categories