How to use Sum?

[#1]

Hi All,

I have one table:

Amount, Discount

1000,0.1

3000, 0.2

Now I want to get the total Amount *Discount

Does Sum support Sum(Amount*Discount) ? If not, how to handle this?

Thanks.

[nagaiank]

Yes. Sum(Sales*Discount) will calculate the discount amount.