Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
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

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!