I have 2 fields in our database, price and discountpc, which are both numeric(15,2). I need to calculate the discount as an amount.

So, for example, if the price is 32.21 and the discountpc is 20.00, I need to return 6.44 as the actual discount value (20% of 32.21).

I have tried:

**ptm.PRICE/nullif(ptm.discountpc,0) DISCAMT**

but using the values above I get 1.61 instead of 6.44

I know there must be a really simple answer but I'm struggling today for some reason!

Thanks

Martyn