I customized the Budget vs. Actual report.
1st column is Actual Amount for Jan. To Oct. 2020
2nd column is Budgeted Amount for Nov. To Dec. 2020
3rd column is a Formula that sums columns 1 and 2
4th column Actual Amount for the year
5th columns is supposed to be a Formula for the Variance of 3rd and 4th columns. But since 3rd column is a Formula itself, I can't select it from the Formula x - y of the 5th column.
Any workaround for this?