For more information, please refer to this announcement explaining best practices for getting answers to questions.
Salary change statement RTFs - rounding off values before performing mathematical operations
Summary:
Rounding off values individually before addition
Content (required):
Hi All,
With regarding to compensation change statements, we're able to achieve Case 1. Is it possible to achieve Case 2 ?
Case 1 - When adding 2 or more numbers, I am able to round off the total sum of these values.
Function used: <?format-number:((CUSTOM_COLUMN_1) + (CUSTOM_COLUMN_2));’9G99G99G999'?>
Eg: 4.8 + 5.5 = 10.3 = 10 (rounded off)
Case 2 - When adding 2 or more numbers, I want to round off the individual numbers before adding them.
Eg: 4.8 + 5.5 = 5 + 6 (both numbers individually rounded off) = 11 (no rounding off required in the sum total as individual numbers already rounded off)
Functions: I have tried different variations of the same function (listed below) but unable to get the desired result: