You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Salary change statement RTFs - rounding off values before performing mathematical operations

Accepted answer
32
Views
8
Comments
in Compensation 8 comments

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:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!