HI All, I have requirement to accept an amount value of having 20 digits an

manikantap918 over 9 years ago

HI All,
I have requirement to accept an amount value of having 20 digits and 2 decimal points and show the amount in currency format i.e., "$23,212,321,232,123,212,321.05" I am able to implement it for 14digits and 2 decimal points but unable to get it for more than that it is giving "~" symbol if we enter more than that . Can any one please suggest how can we acheive this without getting this approx symbol and it has to allow up to maximum of 20 digits and 2 decimal points.

Thanks in Advance,
Manikanta P

Discussion posts and replies are publicly visible

0 utkarshs over 9 years ago

Hey, are you using floating point field?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 kumara0002
A Score Level 1
over 9 years ago

use local variable in the value:"local!variable" and save this into your desired variable using saveInto:ri!desiredvariable << local!variable
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Stefan Helzle
A Score Level 3
over 9 years ago

You these large numbers you have to use a variable of type text and a text field. Appian saves decimal numbers as double precision floating point which can not save such large numbers.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 kumara0002
A Score Level 1
over 9 years ago

Use a!textField(label:"Amount",value:local!variable,saveInto:ri!desiredvariable <<todecimal(local!variable)) .Before saving convert it into your desired data type which you have in the database.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 PhilB
A Score Level 1
over 9 years ago

As Stefan said, for very large numbers you must use a text field; it's worth having a look at the regular expressions plugin as you'll need to validate the inputs to the text field.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 giridharn over 9 years ago

As others suggested you can use text field to solve this but only if you don't need to perform any mathematical functions like addition,subtraction etc. on that number. If you want to perform those operations, then you will run into issues like rounding. If you need to perform those operations, you could write a custom expressions using java bigdecimal that can perform those operations and give you back number as text
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 manikantap918 over 9 years ago

Thanks all,,
I have used text field and custom expressions to acheive the currency format for such large numbers.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel