Forum Discussion
Delta % calculation
IMHO, it depends on business logic behind. If I had -$20 loss on previous year and have $100 this one, difference is $120 and formula shows "not available" for % difference.
Another point, if both A1 and A2 are zeros, usually % is shown as zero.
Without knowing the content formula is a bit abstract.
The advantage of %change is that it is scale invariant; it does not matter whether the denomination is $ or $M. Your delta of $120 may or may not be significant; a change from $1,000,000 to $1,000,120 is a drop in the ocean.
On the other hand, in your example where the base value is -$20 (a loss) the percentage change is -600%. To be honest, that means very little to me and I would sooner view the actual amounts.
Sure, $ I took only to be bit more close to real life with example.
Wish you +600%