Is there a formula that can do this in a calculated column:
{Sold YTD} divided by the number of months since April 1st
For example if we sold 100 so far this year and based on the date, we've only completed 2 months this fiscal year, then we've sold on average 50 per month.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario