Issue with Decimal Values

A Score Level 1

Hi All,

We are fetching data from third party database. One of the columns is of datatype NUMBER in database but contains decimal value like '13896131045.754763294913629859'. While retrieving the values from this column through queryentity, it is returning round off value '1.389613e+10' (in Appian, the column is of type Number(Decimal)).

We are required to retrieve exact value from database as we are doing some checks on this value.

Is there any way of retrieving the exact value.

Thanks and Regards

  Discussion posts and replies are publicly visible

Parents
  • Hi Ravi.Joshi,

    As the other practitioners said that " change the dataType number(decimal) to Text dataType.
    Or else, You can use fixed() function to get the exact value. This function Rounds the specified number off to a certain number of decimals and returns it as text, with optional commas.

    For Example,

    fixed(ri!num,15,true())

    Or else you may try with text() function.

    Regards,
    Aswini
Reply
  • Hi Ravi.Joshi,

    As the other practitioners said that " change the dataType number(decimal) to Text dataType.
    Or else, You can use fixed() function to get the exact value. This function Rounds the specified number off to a certain number of decimals and returns it as text, with optional commas.

    For Example,

    fixed(ri!num,15,true())

    Or else you may try with text() function.

    Regards,
    Aswini
Children
No Data