We had the percent variance column as variance / Budget. The total percent variance on the Total row also calculated as variance / budget. That is, it adopted/used the same formula as the percent variance column, which is expected.
I then modified the variance column formula using If function such that
if the variance is negative, the percent variance should be negative and if variance is positive, the percent variance should be positive
=If(Budget = 0, 0, If(Budget < 0, -1*(Variance / Budget), (Variance / Budget) ) )
Now the total percent variance on the Total row no longer uses the same formula as the variance column, it just sums up the variance column instead of calculating as total variance / total budget.
Is there a way to still make the total percent variance use the same formula as the rest of the column? Is it possible to create a new Total row and modify the formula as it should be?
Thank you !!