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 sridevik7401
Certified Lead Developer
over 7 years ago

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

tointeger(text(20000000,"00000000")) -----> 20000000
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sridevik7401
Certified Lead Developer
over 7 years ago

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

tointeger(text(20000000,"00000000")) -----> 20000000
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data