Is it possible to add up the calculated value on each band of a report into a variable?
Reason I ask is that I have a report which rounds up litres to full container sizes per application date and this does not tally with total litres divided by container size.
I resolved this with a SQL - sub-select for now which provides the same result, but perhaps in future it will require much less resources not to run a query for each sub total, by using a local variable.
If you have a way of implementing such variables already please advise.