I dont get it :-) Get Discounted price by porcentage

[AlexeiXX3]

Hi thanks for looking I have a weird situation here im doing a case on a column, i need to get the final price Price = 15.0000 Discount = 10 when '%' then dbo.vwProducts.Price * ((100 - dbo.Promos.Discount) / 100) Shouldnt this give a result of 13.5?? (15 * ((100-10)/100)) It gives .0000 If i change the 100 for a 10 it works!! It gives a result of 135.0000 (15 * ((100-10)/10)) = 135.0000 Whats happening??

Alexei Rodriguez

[Ashfield]

Check your data types. I just tried it with price and discoutn as decimal and it worked. I changed discount to int and got zero. Hope this helps

Bob Ashfield Consultants Ltd

[Sgg245]

Hi, You are doing division and multiplication through only int datatype only. Do type-casting of one of the variables or value. say (price * ((100-10) / 10.0)) Hope this shud work 4 U... :)

Regards SG

[AlexeiXX3]

Datatypes were were the problem :-) Thanks a lot

Alexei Rodriguez