Hi,
I have a column id(decimal) on the screen it is Appian displaying as 4.495757e+08
I have tried tostring() and text(id, "0*")
Could anyone please tell how can we handle values like this.
Discussion posts and replies are publicly visible
You could use fixed function to display decimals with long decimal places.
Thank you agam
As a best practice, what data type should be given to hold long numbers like text or decimal and then format using fixed function on screen.
I think that numbers should be stored as numbers with the exception of too large numbers will not fit the Appian data types.
If I give the data type as number(decimal) then will it able to capture all the digits.(eg:15 digits)
Hi b0002
Yes, you should store numbers as decimal as long as they are within the database limits.
and, if your use case is to handle max 15 digits, then yes, decimal would capture all the digits easily.
However, it finally depends on your use case, in case you want to store a large number as text.