Add Sales by quarter

[tjbennett]

Can anyone start me in the right direction for writing a formula to add sales by quarter? I want to check if today’s date is say - in the 2nd quarter of 2005 then add 2nd Q of '05 + 1st Q of '05 + 4 Q of '04. I will always be adding the 3 quarters but depending on when I run the report depends on what quarters to add. Also, not real sure how to add quarters from a previous year. I would really appreciate any guidance from the guru's here.

Thanks.

 

[lbass]

Try a record selection formula like:

{table.date} in dateadd("q",-2,currentdate-day(currentdate)+1) to currentdate

In the report, if you want to compare results between quarters, you can group on {table.date}, using "print on change of quarter".

-LB