number format

Hi All,
we have a big number like 20000000
When we try to map it we discover that Appian changes this number as 2e+07
If we use the funcion fixed() we heve the number with comma separator ... 20,000,000
We need to have the number as is, without comma

How can we do that?

OriginalPostID-260664

  Discussion posts and replies are publicly visible

Parents
  • @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*/
Reply
  • @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*/
Children