Hi All
AGGR help seems a common theme, so I hope someone can help me as I've not used AGGR before. However, it's important to note I think aggregate is what I need, I may need a different bit of functionality.
Basically, I have a table, like that below;
Area Grant Actual Budget
A 111 100 200
A 111 200 400
A 111 200 500
A 222 400 200
A 222 400 200
A 222 300 200
A 222 200 200
I want to display the value of overspend for grants by area. So Grant 111 has not overspent, they have underspent by 600. Whereas Grant 222 has overspent by 500. This nets off at an underspend of 100.
However, my table should state
Area Overspend
A 500
Can anyone offer me any guidance on how to do this please?
Many thanks
Steve
