Currency Rounding Problem

[MattR79]

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

[DataNath · Accepted solution]

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!