SUB ({budget}, {Actual Expenses}) Native - calculated

Hi James -

Since you are running a project report you won't be able to pull in the data from a lower object quite the way you would think. 

• Typically you can report up on objects but not down however there are a few workarounds with things like collections to get task information into a nested column. You could do a collection reference to also get expense information but you wouldn't be able to do the calculations you are trying with it.

• Since your calculated fields are on individual expenses there isn't a true sum of these values stored together for you to reference to add and subtract again. You would first need to find a way to calculated the total sum for each calculated field across your various expenses. 

I would suggest looking into running an expense report to get the data you need instead of a project report. Then you can work with summing the columns, etc. You might even be able to build some calculated fields to get that information to the project and then report it out.