Discoverer - Summary Grouping Question..
From: Tom Bellmer <tbellmer_at_sky.net>
Date: Sat, 4 Mar 2000 21:33:28 -0600
Message-ID: <dBkw4.79$uZ6.9116505_at_alpha.sky.net>
I have a calculated field/item. It is calculated at the detail level. For instance, there is a price field and based on whether the value of the price we determine what type of pricing they received. If the price is $5 or more than they received regular pricing. If the price is less than $5 then they received promotional pricing.
In code: Price_Class = DECODE(SIGN(price - 5),1,'R','P')
Date: Sat, 4 Mar 2000 21:33:28 -0600
Message-ID: <dBkw4.79$uZ6.9116505_at_alpha.sky.net>
I have a calculated field/item. It is calculated at the detail level. For instance, there is a price field and based on whether the value of the price we determine what type of pricing they received. If the price is $5 or more than they received regular pricing. If the price is less than $5 then they received promotional pricing.
In code: Price_Class = DECODE(SIGN(price - 5),1,'R','P')
What I want to do is to have a summary table that shows the sum of the price grouped by it's price_class. Can this be done? If so how, because when I attempt to include it in the summary table it will allow me to have a count the min or the max.
mailto:tbellmer_at_sky.net Received on Sun Mar 05 2000 - 04:33:28 CET