Need a formula for a running 12 month sales field...

[arachnoid]

I need a date function, or a formula that will allow me to sum the past 12 months sales in a constant rolling format.

Any suggestions???

Thanks in advance.

 

[synapsevampire]

Try:

{table.date} >= dateadd("m",-12,currentdate)
and
{table.date} <= currentdate

This can be in a Running Total in the Evaluate usea formula.

Or you can use it in a formula to be summed by making it an IF:

If {table.date} >= dateadd(&quot;m&quot;,-12,currentdate)
and
{table.date} <= currentdate then
{Table.Value}
else
0

You can place this formula in the details, right click it and select Insert Summary->Sum

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com