RE verification of line item formula from SYS01 Time Setting by week module

abhi12K
abhi12K
in Modeling

Hi ,

 

Please guide me if i used wrong formulae for below line item.

 

abhi12K_0-1641209006330.png

 

Thanks

Tagged:

Best Answer

  • JaredDolich
    JaredDolich
    Answer ✓

    @abhi12K 

    You have two options for this line item.

    1. Leave it editable and just check the first week as TRUE.
    2. Use this formula: OFFSET(1, -1, 0) = 0.  This will go back one period. If it's not a valid period then it will equal zero and set this formula to TRUE.

Categories