Average object

I would like to create an object to calculate the average of a value YTD. Is it possible to do this in Designer ? Right now I have an object that returns the value (YTD) and I’m calculating the average in the report. However, this is returning a lot of data when I could have the calculation done on the server and just return one number.

Thanks,

Carmen.


cdb (BOB member since 2004-04-09)

Add another object that counts the number of rows you are including in the YTD sum. Like count(row_key).

Then return the count object and the YTD objects in your query and calulate the average in the report.


Michele Pinti (BOB member since 2002-06-17)