Bill - You can create a report variable as an aggregate function:
vAverage = (AVG(Columnname)) FROM tableview WHERE ... vAverageDifference = (Columnname - .vAverage) The key to using aggregate functions in a report lookup is to enclose the aggregate function within its own set of parens. Sami ------------------------------------------ Sami Aaron Software Management Specialists 19312 W 63rd Terr Shawnee KS 66218 913-915-1971 mailto:[EMAIL PROTECTED] www.softwaremgmt.com > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bill > Niehaus > Sent: Sunday, August 15, 2004 11:36 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Rbase 7.1 report with functions > > > I would like to display a report with a value from a table along with an > average for a group of values from the same table. Then I would like to > subtract the average from the current value. I'm not sure how to get > an average calculated and into a report. > > Thanks. > > Bill Niehaus > > > >
