So I have a report that I am trying to create a field to show percentage difference.
In my report it lists offices and their totals $ for the year (2 columns 2019 and 2018)
In the report footer I am using a formula to sum each of these to give grand totals
Sumof2019 ($7017,425.12) and Sumof2018 ($8,059469.54)
I am trying to figure out how to add a percentage difference field.
I tried this...
=Sum([SumOf2019 Gift Amount])/Sum([SumOf2018 Gift Amount])
But it gives me the percentage 84% which is I guess how close 2019 is to 2018 but I am trying to get the percentage difference which should be that we are down 14%
Any ideas?
Nicol