Issue with Decimal Values

Question

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

Aswini · Answer

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

deviratnamv · Answer

Hi Ravi, 
You can change datatype number(decimal) into text, then it will works as your expectations.

ravalik · Answer

Hi Ravi.Joshi, 
 
As per my understanding you need to change the dataType number to "text", then it is possible to retrieve the exact value . 
 
Thanks, 
ravalik