calculating percentage of year passed (for sales reports)
Can you provide an example?
--
Regards,
PJ
Please rate this post using the vote buttons if it was helpful.
"morneauja" wrote:
I've figured out how to calculate the percentage of the month and quarter
passed, but the options for calculating the percentage of the year passed
have not worked. I keep getting either a vary large percentage or an
infinitesimally small percentage. I know that it is possible to calculate
this because I've seen it on some reports, unfortunately reports were pdf'd
so I can't dig around in the spreadsheet to figure out what the formula is.
Thanks, Julie
|