Question

issue building table data in email body, it cut the decimal value to 7 digits

Forum|Forum|2 years ago
March 26, 2024
5 replies
0 views

Hi there

I am doing something which display the table data in email body. but there is an issue: for decimal value, when building the table data. it automatically cut to 7digits, like I have the value it's "2671266.78", it cut it to "2671266", tried function "tostring" and "touniformstring", it does not work. please any one know how can we keep the whole value?

Regards,

Lin

karumurua531442

hi [mention:a081bac65dfa428695332c857e7be932:e9ed411860ed4f2ba0265705b8793d05] could you try this code and let me know is it working

text(2671266.78,"#######.##")

L

linp0001Author

it's working, thank you very much!

karumurua531442

Hi [mention:a081bac65dfa428695332c857e7be932:e9ed411860ed4f2ba0265705b8793d05] good to hear it is working. Could verify our answers so that this we thread will be marked as verified answers.

mikes0011

Brainy

Appian renders numbers in unintuitive ways sometimes - what I believe is happening in your case is that it's arbitrarily deciding what digits are significant enough to display when cast to plaintext in your email. The suggestion Abishek gave above, using the text() function to force a given format, is what I'd suggest trying first.

The Expression Guru

L

linp0001Author

Yes, it's working with text function. thanks.

Sign up

Login with SSO

Login to the community

Login with SSO