The function todecimal is not maintaining the precision I need. I have a simple

scottl189 over 10 years ago

The function todecimal is not maintaining the precision I need. I have a simple currency component defined on a SAIL form (similar to what is in the reciped), but the user may enter fairly large numbers. The issue is when the fn!todecimal is called on the saveinto we lose our precision when the number is of a certain size. For example:
todecimal(56555.25) returns 56555.25 but todecimal(567555.25) returns 567555.3

We do not want the value to be rounded, and instead want to maintain our precision. Is there a way around this?...

Discussion posts and replies are publicly visible

Parents

0 vanmathyv
Certified Lead Developer
over 10 years ago

Hi Scott,
You can use fixed() function for your use case.
Here is the link for your reference,
forum.appian.com/.../Text_Functions.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 vanmathyv
Certified Lead Developer
over 10 years ago

Hi Scott,
You can use fixed() function for your use case.
Here is the link for your reference,
forum.appian.com/.../Text_Functions.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data