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

Hi ,


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






Best 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.