To get Boolean true after every 2 or 3 months
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)
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)