SCENARIO

In datasets, quantity fields are automatically rounded to two decimal places when added. For example, if the actual data is “Gold Screw – 0.045 gm” and “Gold Chain – 0.050 gm,” the dataset displays both as 0.05 gm.

SOLUTION

Apply the formula

TO_CHAR({field_id}, ‘9999999990.000’)

‘9999999990.000’ ensures three decimal places are always shown.

You can adjust the number of 9s based on the maximum expected digits.

OUTPUT

Gold Screw : 0.045gm

Gold Chain – 0.050 gm