P&L Report - Nested Variances / Variance of Formula Columns
I was able to add columns on a report to show tracked category subtotals alongside category totals, then I used 3 formula columns to show the category totals excluding the tracked category values and then the variance by $ and % excluding the tracked category values.
It would be nice instead to be able to make Variance columns that will refer to other Variance columns and/or Formula columns. This way, I gain the benefit of colour coding and arrows for these formulae, making them more directly comparable and more visually consistent!
1
vote
Heide Baer
shared this idea