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 PhilB
A Score Level 1
over 7 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 PhilB
A Score Level 1
over 7 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data