Re: Manipulating Aggregate Function Values

["Korbel Gordon E." <GEKORBEL@NORSTAN.COM>]

This may not answer the question you are asking, but try

Begin-select ....

        Sum(table.field) &sum_col
....
end-select

Reference the summed/aggregated field using the '&Sum_Col' identifier.

-Gordon Korbel

> -----Original Message-----
> From: Bergeron, Marc, Herndon [SMTP:BergeronM@ALPA.ORG]
> Sent: Tuesday, August 25, 1998 3:43 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Manipulating Aggregate Function Values
>
> It's great to be able to use Aggregate functions (MAX, SUM,
> COUNT(*).....) in SQR but how does one multiply the resulting SUM() by
> -1 or PRINT COUNT(*).