The “round(value, n)” function in the Assette Data Object Editor allows users to round numerical values using standard bankers rounding. This rounding method ensures that values ending in .5 round to the nearest even number.
Syntax #
- value – The numerical value to be rounded.
- n – The number of decimal places to round to.
Basic Rounding #
round(10.56, 1)
Result: 10.6
Understanding Bankers Rounding #
Bankers rounding (also called round half to even) follows these rules:
- If the digit being rounded is less than 5, round down.
- If the digit being rounded is greater than 5, round up.
- If the digit being rounded is exactly 5, round to the nearest even number.
Use Cases #
- Ensuring consistent financial calculations.
- Controlling decimal precision in data presentation.
- Standardizing numerical outputs for reports.
By using the “round(value, n)” function in the Assette Data Object Editor, users can efficiently format numerical values while adhering to industry-standard rounding rules.