Solved

Number in scientific notion

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.

Best answer by agamb0001

You could use fixed function to display decimals with long decimal places.

[View:https://docs.appian.com/suite/help/22.1/fnc_text_fixed.html]

You could use fixed function to display decimals with long decimal places.

[View:https://docs.appian.com/suite/help/22.1/fnc_text_fixed.html]

Thank you [mention:d8b421a354554ef089fa196070da6bf2:e9ed411860ed4f2ba0265705b8793d05]

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.

Brainy

I think that numbers should be stored as numbers with the exception of too large numbers will not fit the Appian data types.

Sign up