decimal update issue 0.115380 not getting updated to 0.1154

swiftinitpvtltd

0.115380 not getting updated to 0.1154
We have 6 decimal points in both columns but when user tries to update it remains 0.115380 if we change it to 2 or 3 then it updates.
So aware im thinking value not changed at all.
How to deal with this issue?

BO1.TrackPrice=LoggedInSystemUser.NewBulkPrice

This is simple rule and it works when value changes to 2 or 3 or 0.14 etc.

swiftinitpvtltd

so this works

0.115200 so upto 4 decimals its updating otherwise its considering as not changed.

Our format value for both is #.000000

ACDC

If you use the ROUND function in a rule on the Object.Attribute it will work every time
e.g ROUND(Object.Attribute,6)
number format
#,######0.000000

swiftinitpvtltd

thanks, I tried this somehow its not working. When I manually put
BO1.TrackPrice=0.115380 it works but not
BO1.TrackPrice=LoggedInSystemUser.NewBulkPrice

in db value in LoggedInSystemUser.NewBulkPrice shows 0.115380

Also tried
ROUND(Object.Attribute,6)
BO1.TrackPrice=ROUND(LoggedInSystemUser.NewBulkPrice,6)

ACDC

Replace the 6 with a 4 in ROUND(...
and likewise change the number format to .0000

swiftinitpvtltd

ok thanks, but we need both 4 decimals and 6 decimals few times.
so in some cases user will put 0.115380 and in some rows 0.1154 and he may change 0.115380 to 0.1154 later and vice versa