Level 2 - Sprint 3 - 3.3.5.2

Yogitha

Let me know, if what I did is right or not

 

Create a Filter 

You will need to create two Boolean-formatted line items in the SYS01 Time Settings by Week systems module:

• Line Item Name: First Week of Timescale? 
  • Use this Boolean-formatted line item to select the first week of the timescale. 
  • End users can manually select the first week in FY20.
• Line Item Name: NOT First Week of Timescale? 
  • The formula for this line item should be NOT First Week of Timescale? (referencing other line item above).

 

Misbah

@Yogitha 

 

By looking at the description I think that you are right but if you want to code it you can also use

 

OFFSET(1,-1,0) = 0 like the way I mentioned it in your previous post

 

Thanks,

Misbah

Miz Logix