I need a formula to calculate avg 2 months sales on each item.
If I were basing it last years sales, I would use:
{Sold LY}/6
But I also want to include this year sales:
{Sold YTD}/todays date minus April 1, 2012 divided by 2
Anyone know how to do this? It doesn't have to be exactly 2 months avg, just something close. Also, rounded to zero decimal places.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario