To get Boolean true after every 2 or 3 months

Hi All,

 

I want to make a boolean check after every two months. (Based on estimate and budget customized version ). How this can be achieved via formula? (It should not be static when the year changes automatically the boolean should move according to time range)

 

aishabhy05_0-1648656298511.png

 

 

Thanks

Tagged:

Best Answer

  • @aishabhy05 

     

    Give this a shot.

     

    In a SYS Time module, create a boolean line item with this formula:

     

     LAG(1, 1, 0, STRICT) = 0 OR MOVINGSUM('Every 3rd month', -3, -3)

     

    2022-03-30_11-20-08.png2022-03-30_11-20-23.png

     

    Rob