1 of 1 people found this helpful
The two solutions here are either to do what you are doing in created calculated fields or to unpivot this data in the database itself.
It would likely be a better, more usable structure for future reports to have each "Account Type" as a column. In places where the School/SchoolType/Account dont have a value for a given Account Type, you would just end up with a null in the new structure.
If you want to use REV, EXP and NETINCOME as 3 values, then that's the way to do it.
If you only want NETINCOME you could do something like this:
NETINCOME => Sum(if AccountType = "Revenue" then [amount] END) - sum(if AccountType = "Expenses" then [amount] END)
But basically when you have the data in that structure (ie Acct Type and Value as 2 columns), then you have to split it out when you want to calculate between different types like this.