...
5. Compare Actual and Budget with Variance %
| Column No. | Column Header | Column Type | Ledger Entry Type | Amount Type | Formula | Comparison Date Formula | Comparison Period Formula |
|---|---|---|---|---|---|---|---|
| 1 | Actual | Net Change | Entries | Net Amount | |||
| 2 | Budget | Net Change | Budget Entries | Net Amount | |||
| 3 | Variance | Formula | Entries | Net Amount | (1-2) | ||
| 4 | % | Formula | Entries | Net Amount | (1-2)/2*100 |