I’m having issues properly showing the growth and variance of negative items.
As an example, if actual EBITDA was -0.25 and budget was -1.0, I can get the difference to display correctly, but my only options for % variance are
- -75% (-.25- -1.0)/-1 or
- +300% (-1- -.25)/-.25
Neither of those are correct. It should be +75%. I can use “Reverse Signs” but that doesnt apply to conditional formatting.
Has anyone figured out a better way to show this in a table?