
I am trying to figure out if there is a way to calculate a variance to budget showing better(worse). So for revenue (credit accounts/lines) I would take actual minus budget and for expense accounts (debit accounts/lines) I would take budget minus actuals. My report compares actual month to budget, actual to prior year and the same columns for year to date.
For the variance columns only I need the revenue, other income and net income lines to be actual minus budget and all the expense lines and subtotals to be budget minus actual. It seems to me I need to do this in the Column set but it is only for certain rows and I am not sure how to accomplish that if it is even possible.
*This post is locked for comments
I have the same question (0)