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

abhi12K
Contributor

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.

 

abhi12K_0-1641209006330.png

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
JaredDolich
Moderator

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

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

Jared Dolich

View solution in original post

1 REPLY 1
JaredDolich
Moderator

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

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

Jared Dolich