How would I round a calculation in a template in DBManSQL?
My calculation is as follows:
<%MSRP - $Price%>
This takes "Retail Price" minus "Sales Price" and returns "YOU SAVE" value.
It does the calculation correctly, but occasionally produces a long value.
ex. $8.72000000000001
See an example here:
http://proline2000.com/...4030304&CatID=23
I want to round to the nearest currency decimal.
ex. $8.72
Any help would be appreciated!
Thanks,
Rick
http://www.proline2000.com
Pro-Line Direct Electronics Superstore
My calculation is as follows:
<%MSRP - $Price%>
This takes "Retail Price" minus "Sales Price" and returns "YOU SAVE" value.
It does the calculation correctly, but occasionally produces a long value.
ex. $8.72000000000001
See an example here:
http://proline2000.com/...4030304&CatID=23
I want to round to the nearest currency decimal.
ex. $8.72
Any help would be appreciated!
Thanks,
Rick
http://www.proline2000.com
Pro-Line Direct Electronics Superstore