number format

Fixed has an option to not add commas - as documented here: docs.appian.com/.../Text_Functions.html

The recommendation I've had from Appian is to use a text field and fixed () to display larger numbers.

@eliav....In fixed function use like this..

fixed(20000000,0,true) --->20000000

@eliav...you can also try this way..

tointeger(text(20000000,"00000000")) -----> 20000000

@eliv, fixed() and tointeger() is for particular range..if exceeds that range it wont work. AFIK, it's better to go with text().

i agree with philb , you should use text field for large values.

text(2000000000000,"00000000") ---> N/A

@eliav consider the above improper text() expression to avoid range problem.
Have a look at the below proper text() expressions i.e., the fundamental trade-off between text() and fixed. In case of calculation related usage consider fixed(), in case of display use text(). Do not mix both in case of mathematically critical scenarios.
/*text("20,000,000.00","00,000,000.00") --> 20,000,000.00*/

/*text("20,000,000,000.00","00,000,000,000.00")--> 20,000,000,000.00*/

/*fixed(text("20,990,000,987.00","00,000,000,000.00"),0,true) --> 20990000987*/

Solved, thank you

Not working for more then 17 character