Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Rounding Problem 1

Status
Not open for further replies.

xterra

Programmer
Apr 5, 2001
71
US
I'm sorry if this has been asked but i couldnt find a solution anywhere. I need my number to round based on the ten-thousandths but only display to the hundredths. I am just using round({@OtherCountyMortgageCounty} * .05,4)

My number is 11.7245 that i end up with. It trys to round this to 11.72 everytime but i need it to round it to 11.73

Any Ideas?

Thanks,

Adam
 
Try using a formula like:

round(round({table.number},3),2)

-LB
 
Worked perfectly thank you so much
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top