Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Rounding rule to be used for numeric column
Summary:
Content (please ensure you mask any confidential information):
Hello experts,
we enabled a numeric column displaying 2 decimals. However, in this column customer can still potentially enter 3 or more digits (the system automatically will round it). However, I've noticed that if I enter 1,22 the calculated column based on the number I enter display the expected result, but if I enter 1,223 the system will display 1,22 but the result is different. Which of the available rounding rules I can use to get the same result if I enter 1,22 or 1,223?
Thanks in advance for your help!
Kind Regards,
Valerio
Version (include the version you are using, if applicable):
0