Random numbers keep appearing after the decimal for the numbers. (47.3 shows as 47.3000000004, etc.)

Certified Associate Developer

We are trying to enter a decimal number into a!floatingPointField and storing it in Number(Decimal) field. Since it is a decimal we are trying to save it using rounddown(value, 2) so as to allow only 2 decimals according to our requirement. Note: This functionality is being used in editable grids. While doing so, for certain fields we are getting random numbers keep appearing after the decimal for the numbers. (47.3 shows as 47.3000000004, etc.). This is happening only for that particular row for only a specific value i.e in the example 47.30 only will show 47.3000000004, if we enter 47.322445 it will round down to 47.32.

We tried using, round(), roundup(), rounddown() and floor(). SInce we have mutliple grids in the same fashion, this issue seems to appear in atleast 1 grid row.

  Discussion posts and replies are publicly visible