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

Question

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

Abhishek Karumuru · Answer

hi linp0001 could you try this code and let me know is it working text(2671266.78,"#######.##")

Mike Schmitt · Answer

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.

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

Top Replies