Issue with Appian text() function and decimal formatting

Question

Hi All,I’m seeing unexpected behavior with the Appian text() function when formatting a decimal value.For example:text("2.00000001", "0.0000000000")I would expect the output to be:2.0000000100 I’m getting:3.00000000000Has anyone encountered this behavior before?Is this related to how Appian is interpreting the first parameter as a number/decimal, or is there something specific about the text() format "0.0000000000" that I’m missing?Any explanation of why the value is being returned as 3.00000000000 would be appreciated.

tukaramp758935 · Answer

Hi ​@sairohitd054766,I came across KB-1426 – Unexpected results on decimal calculations and rounding, which discusses unexpected results when working with Appian Decimal values due to the limitations of IEEE 754 double-precision floating-point representation. It also includes an example involving the text() function.I also tried using the fixed() function with the same value:fixed(2.00000001, 10)In my test, this returned:2.0000000100So, as a possible workaround for the formatting requirement, you could try using fixed() instead of text().Hope this helps!

Sign up

Login with SSO

Login to the community

Login with SSO