Forum Discussion
MarkShnier
13 years agoQrew Cadet
What I do is to set an extra checkbox filter on the report such as
if(rem(month(today()),3)=1,True,false)
or just
rem(month(today()),3)=1
So for example, if its April 1st today (Month #4) and you divide 4 by 3 you get a remainder of 1. So it would be True, so the report would have data on it. Then in May, it would be month #5 and 5/3 leaves a remainder of 2 so it won't fire that month because the report will be blank.
It does mean that you need to make a second "copy" of your report just for the purpose of the Subscription.
...P.S. .. for semi annually the formula would have 6 in place of 3.
if(rem(month(today()),3)=1,True,false)
or just
rem(month(today()),3)=1
So for example, if its April 1st today (Month #4) and you divide 4 by 3 you get a remainder of 1. So it would be True, so the report would have data on it. Then in May, it would be month #5 and 5/3 leaves a remainder of 2 so it won't fire that month because the report will be blank.
It does mean that you need to make a second "copy" of your report just for the purpose of the Subscription.
...P.S. .. for semi annually the formula would have 6 in place of 3.