I have the below table and want to round Rent Balance to two decimal places and the result should match as in the Required column. I tried using the Round function but that does not give the desired result. Any ideas how I can use a formula or tool to achive this please.
A caution: Using this approach will convert null values to 0s. To keep these as null values, you'll need to use another multi-field tool to convert them back to null:
IF [_CurrentField_] = 0 THEN Null() ELSE [_CurrentField_] ENDIF
