This content has been marked as final.
Show 2 replies

1. Re: Calculating Percentage of MTD compared to Previous MTD
Ivan Young Mar 15, 2018 10:29 AM (in response to Jonathan Hodge)Hi Jonathan,
What percentage are you trying to calculate. For example the % gain in September 2017 is relative to what? Previous month, parameter month, previous year?

2. Re: Calculating Percentage of MTD compared to Previous MTD
Jonathan Hodge Mar 15, 2018 10:59 AM (in response to Ivan Young)For this example I'd like to compare my snapshots of whats in the workbook. Can we find the percentage difference from current month MTD of sales compared to previous month MTD of sales?
44,098/53,981
That is 81%. I guess the "% Gained" should be 19%. So 19% is what I am looking for. But I could get that from finding the 81% as well.