Level 2 - Sprint 3 - 3.3.5.2

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

 

2022-10-13.png

Comments

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

  • Yeah exactly, as per the activity description  no need of any formula for the first line item right. 

    So, can I keep it blank?

  • @Yogitha 

     

    Follow the instructions, if they say no formula then no formula but that first box needs to be checked. You can manually check that box as of now but if you need the formula you know what the formula should look like.

     

    Misbah

    Miz Logix

     

     

  • What should be checked?

     

    2022-10-13 (1).png

  • @Yogitha 

     

    First week of timescale i.e, Week 1 FY20 only