2 weeks ago - last edited 2 weeks ago
Hello Community,
From the above image, you can see TM (dynamic calc), TMStored (stored calc).Here, If my current period is 2023M5,then it should skip current period and take further 12 periods( 2023m6,2023m7,2023m8,2023m9,2023m10,2023m11,2023m12,2024m1,2024m2,2024m3,2024m4,2024m5).
Below is my code which helps me to get same data from 2023m6 to 2023m12 only,it is not taking further remaining 5 periods.
2 weeks ago
I suspect the auto-calculated View you're using doesn't cross the year threshold. Just write some basic logic to check the period and do the calculation differently for the first few periods of the next year?