To get Boolean true after every 2 or 3 months

BlueSky-Wind chaser

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)

 

 

 

Thanks

rob_marshall

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

 

 

Rob