Could anyone please give me solution regarding large decimal number values stori

radhaa over 9 years ago

Could anyone please give me solution regarding large decimal number values storing and validations on it,

I'm trying to give more than 15 digits number with two decimal digits,but it rounds that number to the nearest value and resetting the decimals to 0's.
Example:99999999999999999.99

I used fixed(), text() function to get the solution for this problem, but these also gave same behaviour.
Example: 1. fixed(
                              ri!num,
                              2,
                              true()
                              )

          2. text(ri!num,"##################.##")

Apart from this, in rule inputs and pv's number(decimal) values was stored in exponential form if number is more than 10 digits ex: 1e+15.
I'm using len() to get length of the value, it reruns improper value Ex:5 because Rule input and Process variable storing exponential value.
and If I tried with len(fixed()), it was returning value more than length of the number specified....

Discussion posts and replies are publicly visible

Parents

0 ashleyb over 9 years ago

value: if(isnull(local!stringUnitsPledged), 0, fixed(local!stringUnitsPledged, 5, true)),
validations: if(isnull(local!stringUnitsPledged), null, if(regexmatch("^[0-9]\\d{0,9}(\\.\\d{1,5})?$", fixed(local!stringUnitsPledged, 5, true)), null, "Enter no more than 15 characters")),
saveInto: {local!stringUnitsPledged, ri!exceptionDetails_cdt.unitspledged}

This will accept 10 places before the decimal and 5 after. Anything after the fifth decimal place is rounded.
*Also note that the origional value was stored into a local! string variable, validations were done, then was stored back into the origional decimal field.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ashleyb over 9 years ago

value: if(isnull(local!stringUnitsPledged), 0, fixed(local!stringUnitsPledged, 5, true)),
validations: if(isnull(local!stringUnitsPledged), null, if(regexmatch("^[0-9]\\d{0,9}(\\.\\d{1,5})?$", fixed(local!stringUnitsPledged, 5, true)), null, "Enter no more than 15 characters")),
saveInto: {local!stringUnitsPledged, ri!exceptionDetails_cdt.unitspledged}

This will accept 10 places before the decimal and 5 after. Anything after the fifth decimal place is rounded.
*Also note that the origional value was stored into a local! string variable, validations were done, then was stored back into the origional decimal field.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data