Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Salary change statement RTFs - rounding off values before performing mathematical operations — Cloud Customer Connect
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

Question
1
Views
0
Comments
in Compensation

Hi - while creating compensation change statements, we are using User-Defined Columns for several salary components. The values uploaded to these columns are annual calculated values.


Our requirement is to also display monthly values. Since we don't have any available user-defined columns to store the monthly values, we are deriving the monthly values using mathematical expressions.


Example - if a value of INR 120,000 is uploaded as the annual component in the user-defined column, we use a mathematical operator "div" to divide this by 12 to derive the monthly amount as INR 10,000.


The issue we are facing is around rounding. While I have been successful at adding two numbers and then rounding it off, what we want to achieve is round off the individual entries first and then add them.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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