Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Yes. Sum(Sales*Discount) will calculate the discount amount.