First week of timescale in SYS01 Time Settings By Week

Shengnan
Shengnan
in Academy Discussions

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?

image.png

Answers

  • Rajat26
    Rajat26

    Hi @Shengnan,

    Two ways to do this,

    1. Manually check the first week of timescales, cause its only one should not be a hassle
    2. 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
    Shengnan

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

  • nick_barker
    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.

    image.png

Categories