Skip to main content
R
rithwinv0001
May 28, 2025
Question

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

  • May 28, 2025
  • 4 replies
  • 0 views

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.

    4 replies

    harshas2775
    harshas2775
    May 29, 2025

    For the respective column in database, what is the data type you are using? if you want to store upto 2 decimal places then make sure the data type in database in decimal(10,2)

    M
    madhurih725284
    July 30, 2025

    I have a question 
    as how the wholenumbers and decimal numbers can be displayed in appian read only grid
    as I need integers and minutes to be displayed as wholenumbers and ratio,currency to be displayed as decimals

    harshas2775
    harshas2775
    July 30, 2025

    you can use text() function with desired format you want to show the data in. Perhaps you can share some examples of input and expected Output, then  I will be in better position to help. 

    Terms & ConditionsAccessibility statement