Currency Rounding Problem

I am trying to match some item dollar amount values however, one of them has several digits after the decimal point where the other only has two. There does not seem to be an easy way to round up to the closest second decimal. Any advice on how to do this? Below is an example of what I am trying to do.

Value that needs to be rounded	Desired Value post rounding
3400.2275842	3400.23
198543.016483	198543.02
109.86832	109.87

Tips and Tricks

Accepted answers

DataNath

Hey @MattR79, you can use the Round() function:

Round([Value that needs to be rounded],0.01)

Or switch the Data Type of your field to a FixedDecimal with size N.2 where N allows for the full size of your number including the leading numbers, decimal point & numbers afterwards:

All comments

DataNath

Hey @MattR79, you can use the Round() function:

Round([Value that needs to be rounded],0.01)

Or switch the Data Type of your field to a FixedDecimal with size N.2 where N allows for the full size of your number including the leading numbers, decimal point & numbers afterwards:

MattR79

Wow, that was extremely easy, I feel a little silly now. Thanks for the help.

DataNath

Not at all @MattR79, all part of the learning journey! Anytime!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703