Hi All
I am trying to do a calculation for Month on Month % figures for a list of figures but am finding running into difficulty as some of the percentages are + and some are -. See table below for the calculations I am trying to do so for examples the Month on Month +/- % for 2012-10 is -30.02% as that is the drop in percentage between 39191 and 30143 and the Month on Month +/- % for 2012-11 is 188.20% as that is the rise in percentage between 30143 and 86874.
Month Totals Month on Month +/- %
2012-09 39191
2012-10 30143 -30.02%
2012-11 86874 188.20%
2012-12 126439 45.54%
2013-01 73452 -41.9%
2013-02 105000 42.95%
2013-03 94822 -9.69%
Any help on this would be very much appreciated
Regards
Donal
I am trying to do a calculation for Month on Month % figures for a list of figures but am finding running into difficulty as some of the percentages are + and some are -. See table below for the calculations I am trying to do so for examples the Month on Month +/- % for 2012-10 is -30.02% as that is the drop in percentage between 39191 and 30143 and the Month on Month +/- % for 2012-11 is 188.20% as that is the rise in percentage between 30143 and 86874.
Month Totals Month on Month +/- %
2012-09 39191
2012-10 30143 -30.02%
2012-11 86874 188.20%
2012-12 126439 45.54%
2013-01 73452 -41.9%
2013-02 105000 42.95%
2013-03 94822 -9.69%
Any help on this would be very much appreciated
Regards
Donal