Salary change statement RTFs - rounding off values before performing mathematical operations
Rounding off values individually before addition
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: