Home : Products : DBMan SQL : Discussion :

Products: DBMan SQL: Discussion: Rounding Calculations: Edit Log

Here is the list of edits for this post
Rounding Calculations
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

Last edited by:

rcaudio: Nov 6, 2003, 12:06 AM

Edit Log: