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 is the result of how computers store decimal numbers. When that number is converted into a string, a rounding operation happens.
https://en.wikipedia.org/wiki/Computer_number_format
BTW, are you aware that you pass that decimal number as a string? This could already result in mathematical rounding.
Hi, Stefan
Thank you for your answer.I understood the system.Sorry I didn't know how it worked, any help would be appreciated.