Why {29.19 + 0.05} = 29.24000000002

[natong]

Screenshot_2018-07-08-00-25-19-030.jpeg (264.8 KiB) Viewed 11064 times

Screenshot_2018-07-08-00-28-51-789.jpeg (294.72 KiB) Viewed 11064 times

Please suggestion.

[Desmanto]

floating calculation problem. At times, it will throw such problem. You have to round it. Unfortunately we don't have round() with extra argument to limit the decimal yet. You can use either one of these solution

Code: Select all

a = 29.19 + 0.05 ; // result = 29.24000000002
b = round(a*100)/100; // result 29.24
c = "{a,numberformat,0.00}";  // result 29.24

The b is using universal rounding method, it can round to any number (to round to nearest 7, replace the 100 with 7).
While c is using automagic built-in pattern character to show the number in 2 decimals.

[natong]

Thank. These bug will be fixed in the next version ? or it's android floating bug and can't be fixed ?

[digitalstone]

Not even Android i think. More a fundamental problem/side effect.

[Desmanto]

Yeah, I think it is featured, as Automagic scripting is inherited from java/javascript. Besides, floating calculation problem is a common problem. We have to deal with it, just use round or other method to show it properly. I use both b and c method depends on my need.