I have a question about the text() function.When I used "#" in the second argument to text(), the following behavior occurred.When I tried to match the digits and separators to the format,the numbers after the decimal point changed.The documentation says that "#" is a format for numbers,but does it also convert the numbers themselves?
・document
docs.appian.com/.../fnc_text_text.html
↓exmapletext("12,333,333,333,333.12","##,###,###,###,###.##") → "12,333,333,333,333.11" is returned.
Discussion posts and replies are publicly visible
This might help: community.appian.com/.../kb-1426-unexpected-results-on-decimal-calculations-and-rounding
Hi, Mathieu
Thanks for the answer and for attaching the document.It looks like this can be overcome by using the workaround described in the documentation.