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
Discussion posts and replies are publicly visible
hi linp0001 could you try this code and let me know is it working
text(2671266.78,"#######.##")
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.
it's working, thank you very much!
Yes, it's working with text function. thanks.
Hi linp0001 good to hear it is working. Could verify our answers so that this we thread will be marked as verified answers.