Currency Input Field Rounding Issues with Decimal Values Above 10,000 (Ex.: 200,300.57) - Need Plugin Recommendation

Question

I'm working on a custom currency input field component and facing a challenging issue with decimal value conversion and rounding when values exceed 10,000 (5+ digits). 
 Here's my current implementation: 
 
 a!localVariables(
 a!textField(
 label: ri!label,
 labelPosition: a!defaultValue(ri!labelPosition, "ABOVE"),
 value: a!currency(
 isoCode: a!defaultValue(ri!isoCode, "BRL"),
 value: rule!process_BRLInputSanitizer(
 value: ri!value,
 toDecimal: true,
 showSeparators: false
 ),
 decimalPlaces: 2,
 showSeparators: true
 ),
 placeholder: ri!placeholder,
 saveInto: a!localVariables(
 {
 a!save(
 ri!value,
 a!currency(
 isoCode: a!defaultValue(ri!isoCode, "BRL"),
 value: rule!process_BRLInputSanitizer(
 value: save!value,
 toDecimal: true,
 showSeparators: false
 ),
 decimalPlaces: 2,
 showSeparators: true
 ),
 
 ),
 ri!saveInto
 }
 ),
 disabled: a!defaultValue(ri!disabled, false),
 readOnly: a!defaultValue(ri!readOnly, false),
 refreshAfter: "KEYPRESS",
 validations: { ri!validations },
 showWhen: a!defaultValue(ri!showWhen, true),
 instructions: ri!instructions,
 helpTooltip: ri!helpTooltip
 )
) 
 Supporting Rule (process_BRLInputSanitizer): 
 
 a!localVariables(
 local!toDecimal: a!defaultValue(ri!toDecimal, false),
 local!value: tostring(ri!value),
 local!left: substitute(local!value, ",", "."),
 local!right: substitute(local!value, ".", ","),
 local!result: if(
 local!toDecimal,
 concat(
 left(local!right, len(local!right) - 3),
 right(local!left, 3)
 ),
 concat(
 left(local!left, len(local!left) - 3),
 right(local!right, 3)
 )
 ),
 if(
 a!defaultValue(ri!showSeparators, true),
 local!result,
 if(
 local!toDecimal,
 substitute(local!result, ",", ""),
 substitute(local!result, ".", "")
 )
 )
) 
 
 The Problem: When the system casts the value back to a Decimal type, it rounds the value incorrectly when it exceeds 10,000 (5+ digits). I need the value to remain as a precise Decimal because my Record Type field that integrates with the backend requires decimal format.

Questions: 
 
 Why does this rounding occur specifically when values exceed 5 digits? 
 Is there an existing plugin or component that handles dynamic currency formatting (showing decimal separators while the user types) that maintains decimal precision? 
 If such a plugin exists, it would save me from building this from scratch. 
 
 I'm essentially trying to create a currency input that displays proper formatting (R$323,845.27) while maintaining the underlying decimal value for record Type integration. 
 Any recommendations for existing solutions or insights into the rounding behavior would be greatly appreciated! 
 Thank you all for your time and assistance.

Mike Schmitt · Accepted Answer

Silas. B. Ferreira said: What if, my record type value is a Decimal? How am I going to handle it if the value is always being casted 
 You're overcomplicating this. Store the decimal value only, and only worry about formatting it anytime it's output to a user-facing display. That should be it. 
 
 Silas. B. Ferreira said: Appian will always displays the imprecise value. There is no other way without using a string. 
 The correct decimal value is stored correctly in a decimal type variable, whether that's a record field or CDT field. Remember that what's "displayed" is liable to be different from what's there in the underlying data, when just looking at the default output. Casting the output to text and using the formatting string merely forces the displayed value to look like what you're expecting (but of course this is still a representation of the underlying data).

Silas. B. Ferreira · Answer

Well, I was able to create a workaround and I will share with you all 
 rule!_RFind: 
 a!localVariables(
 local!reversed: joinarray(char(reverse(code(ri!string))), ""),
 local!findIndex: find(ri!substring, local!reversed),
 find(
 right(ri!string, local!findIndex),
 ri!string
 )
) 
 rule!_CurrencySanitizer: 
 a!localVariables(
 local!findComma: rule!_Process_RFind(string: ri!value, substring: ","),
 local!findDot: rule!_Process_RFind(string: ri!value, substring: "."),
 if(
 local!findDot < local!findComma,
 todecimal(
 substitute(
 substitute(trim(ri!value), ".", ""),
 ",",
 "."
 )
 ),
 ri!value
 )
) 
 rule!MoneyField (BRL): 
 a!textField(
 label: ri!label,
 labelPosition: a!defaultValue(ri!labelPosition, "ABOVE"),
 value: a!currency(
 isoCode: "BRL",
 value: ri!value,
 decimalPlaces: 2
 ),
 placeholder: ri!placeholder,
 saveInto: {
 a!save(
 ri!value,
 rule!_CurrencySanitizer(save!value)
 )
 },
 disabled: a!defaultValue(ri!disabled, false),
 readOnly: a!defaultValue(ri!readOnly, false),
 refreshAfter: "UNFOCUS",
 validations: { ri!validations },
 showWhen: a!defaultValue(ri!showWhen, true),
 instructions: ri!instructions,
 helpTooltip: ri!helpTooltip
) 
 
 Special thanks to Mike Schmitt . If any of you have any other suggestion, please don't hesitate

Mike Schmitt · Answer

So basically my prior answer is correct:

Mike Schmitt · Answer

Silas. B. Ferreira said: However, I am wondering as well if Appian is gonna pass the real value when it's expected to be a decimal 
 The "real value" is what's being stored in Appian, which is what I'm trying to show you. The rounded value you're seeing in the local variables panel is merely a "user facing" output, not the internal value.

Mike Schmitt · Answer

Appian's default way of displaying decimal numbers takes some sometimes unintuitive liberties with the number of significant figures shown - in ways that are a little unintuitive and opaque to not only the end user but also the designer (frustratingly). I'm not exactly sure I'm comprehending the manual conversions you're with your utuility rule, but I was under the impression that a!currency() was supposed to handle things like "dots instead of commas and commas instead of dots" automatically for currencies that use opposing systems (though i haven't tested this). BTW, are users not using locales that support the proper number entry system inherently? I thought it worked without manual conversion when the locale was set right (also haven't personally tested though). 
 My general advice at this point would be to go back to basics and make sure you're doing any manual conversion on a displayed number (versus the underlying decimal value) only at the very end , to avoid it becoming confused.

Mike Schmitt · Answer

Could you provide a screenshot of an example of the output you're seeing and the actual underlying value that you'd expect to be seeing? 
 Have you tried formatting the output through functions like 'text(value, "0.00")' to signify that you want the displayed output to show the entire number including 2 decimal places at all times? Because as I said, when just displaying decimal data, Appian (badly) guesses at what level of significant digits should be displayed to the user.

Currency Input Field Rounding Issues with Decimal Values Above 10,000 (Ex.: 200,300.57) - Need Plugin Recommendation

Top Replies