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
Apparently its due to the rounding of the value that happens when a number is converted to string. May be try asking ChatGPT to summarize the answer for you.
Hi, konduru
Sorry I didn't know how it worked, but I understood regarding round.Thank you for your answer.