Most of you probably know this, but I thought I would share because I
will use this all the time.
How often do you need to output a total line at the bottom of a report?
You probably do one of 2 things: 1) Increment a variable while
outputting your query, or b) perform a query of queries.
I found this trolling online and needed to share, lets say you have a
query called 'getData' and a column named 'rev' and you needed a total.
Just do this: #arraySum(getData['rev'])# You can use any array
functions (avg, max, min) against a query column referenced like this.
This seems a lot easier to read to me too!
Chris Peterson
