First week of timescale in SYS01 Time Settings By Week

Dear community,

I struggle with getting the first week of timescale right in the SYS01 Time Settings By Week module. Here is my formula. Could anyone help to have a look?

Accepted answers

All comments

Rajat26

Hi @Shengnan,

Two ways to do this,

Manually check the first week of timescales, cause its only one should not be a hassle
You can create a new line item with Previous(same line item)+1 and the give an if-else to tick the boolean only when the new line item is 1

Shengnan

Thank you @Rajat26 I will go for solution one :)

nick_barker

Hi not sure why the formula you are using is not returning a true for your timescale. I have the same formula and it is returning a true for my first week. See screenshot below.

Quick Links

Can you help?

Unanswered questions

one or multiple models
Does anyone have any documentation on the trade-offs of having 1 model for all components of planning (service revenue, product revenue, labour planning), vs multiple models 1 for each and a consolidation model to tie it all together?
Anaplan XL Calculations
I am still now to the calculation of Anaplan XL, i would like to get the proportion in terms of value between child vs parent (within the hierarchy) For instance, i want to get the % of each 08S( child) vs the parent value (BL TS), i would like IN general a formula that give the proportion of child vs parent dynamically,…
How to synchronize scroll a card/s from the main board and another card/s in the insights panel?
Just like the main question above, I wanted to try out the new feature on the board where you can you the insights panel to put additional cards. However, I wanted to synchronize scroll a card on the main board with the card on the insights panel but I can't find where it might be.