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.
decimal update issue 0.115380 not getting updated to 0.1154
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
Re: decimal update issue 0.115380 not getting updated to 0.1154
so this works
0.115200 so upto 4 decimals its updating otherwise its considering as not changed.
Our format value for both is #.000000
0.115200 so upto 4 decimals its updating otherwise its considering as not changed.
Our format value for both is #.000000
Re: decimal update issue 0.115380 not getting updated to 0.1154
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
e.g ROUND(Object.Attribute,6)
number format
#,######0.000000
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
Re: decimal update issue 0.115380 not getting updated to 0.1154
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)
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)
Re: decimal update issue 0.115380 not getting updated to 0.1154
Replace the 6 with a 4 in ROUND(...
and likewise change the number format to .0000
and likewise change the number format to .0000
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
Re: decimal update issue 0.115380 not getting updated to 0.1154
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
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