number format

eliav over 7 years ago

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?

Discussion posts and replies are publicly visible

Top Replies

davel001150 over 4 years ago in reply to fathimaz +1
Certified Lead Developer

Appian stores numbers in Double floating point type and Integer type under the hood. Double is the more precise one and gives you approximately 16 digits of precision. You can't get more without using…

Parents

0 Dastagiri Dudekula over 7 years ago

@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*/
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Dastagiri Dudekula over 7 years ago

@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*/
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 sauravk over 5 years ago in reply to Dastagiri Dudekula

Not working for more then 17 character
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel