We are trying to do a percentage difference table calculation and when we go from a negative number to a less negative number it thinks the percentage difference went down. Any ideas for a work around calculation?
2013 ROAS: -$0.77
2014 ROAS: -$0.45
Tableau Delta (wrong): -42%
Desired Delta: 42%
I'm getting the correct value. If you could provide more information about your setup I may be able to help you find the problem. My guess is that it is your partitioning, or some other hidden setting for this calculation.