Amount Calculation in decimal field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2024 05:30 AM
Hello,
We have 2 fields with decimal field type (scale =2 in attributes) and we are trying to sum them up and place the result in third box called Total.
Then we have a system property in System Localization which is set as de.DE for Germany (screenshot attached). By default this value is empty, but probably for some requirement it was changed in our instance.
Now with this the problem is if a person enters the value as 23.23, it changes to 2323; and if a person enters the value as 23,23 it changes to 23.23
If the value changes we are facing issues while adding up for total cost and we need this onchange itself as changes in total cost in turn affects another user field.
Can you please suggest how can we go about this?
NOTE : We have tested changing the system localization property in our development instance to empty value then all the decimal field works well, but unfortunately we can't change that to empty value.