Formula that will pull from another LI every other Thursday

Options

Hi,

 

Need help on how to set up a formula for a LI that will pull from another LI every other Thursday?

 

Thank you 

Answers

  • @neg177 Try below approach and see if it works .

    Firstly you are identifying start date of time dimension

    2 - Identify weekday number with the help of formula 

    3 - In boolean LI say  if weekday is = 4 then true

    4- lastly say if boolean is true give me line item value or 0 

    bhatjaved_0-1643062186269.png