I am creating a report that has a summary - total sales for the month.
I have an amount as a base from prior year (that does not change).
I would like to have a formula that takes above sales summary and deducts prior year base. I should end up with increase / decrease value.
Also I need to calculate a percentage of increase / decrease.
Example:
Total Sales January $35,076
Total Base $30,476
Increase/ Decrease $4,600
Percent of increase / decrease 15.1%
Thank you
Edited by Florina - 13 Jun 2011 at 1:51am
IP Logged
