This is working!!
ROUND( (61/365) * {Sold YTD} / YEARFRAC( FISCALSTART() , TODAY() ) , 0)
Yeah!
Now I need to add to this what was sold last year {Sold LY}.
So the result I'm getting so far is successfully showing me 2 months average qty sold based on this year-to-date qty sold.
I want it to show me 2 months average qty sold based on this year-to-date and last year qty sold combined.
Can you help?
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario