Re: Manipulating Aggregate Function Values

["Bergeron, Marc, Herndon" <BergeronM@ALPA.ORG>]

                -----Original Message-----
                From:   Korbel Gordon E. [mailto:GEKORBEL@NORSTAN.COM]
                Sent:   Tuesday, August 25, 1998 5:17 PM
                To:     Multiple recipients of list SQR-USERS
                Subject:        Re: Manipulating Aggregate Function
Values

                Thank you

                Marc Bergeron

                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] <mailto:[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(*).