Re: Aggregate function, Grouping

Thanks Vitali, your example works exactly as I would like.
Cheers!

Vitali Kalinin wrote:

How about this:
SELECT
bl.GR_KEY, bl.GroupOrder, bl.UseOverhead,
SUM (Amount * price) as "SubTotal",
SUM(IIF (bl.UseClientAmount = True,
bl.Amount + bl.ClientAmount,
bl.Amount)) as "RealAmount"
FROM
Budget_Lines bl
WHERE
bl.BU_KEY = :BU_KEY
GROUP BY
bl.BU_KEY, bl.GroupOrder, bl.UseOverhead, bl.GR_KEY


.