• State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 4 replies
  • Answers 3 answers
  • Subscribers 11 subscribers
  • Views 11963 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Data and Records

Issue with Decimal Values

Ravi
A Score Level 1
 over 4 years ago

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
  • +1 over 4 years ago
    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
  • +1 over 4 years ago
    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

© 2023 Appian. All rights reserved.