I have written a select query which checks the price we have charged a customer for a call against what it should cost.
I have my query running fine but i have a small problem where some of my records are to more than three decimal places but the data i am searching against only has a maximum of three which means it is showing up slight differences which i really would like to avoid.
The way my query works is i have a call price, a connection fee and a duration which i am matching against the price per second so:
from table1 innerjoin table2 on
call price-connection fee/duration = price per second.
I have also added an extra field at the select which shows what the price of the call should be and that is what i am using to compare.
i will give you an example:
the price of the call we charge the customer is 0,272 but when the calculation is done on what the price should be the price is 0,271995.
So effectively i would like the query to round this number to 0,272 and then compare!
Sorry for the long winded ness but ive been rooting through the help screens all day and am at my wits end lol!!