Question Re: Business Rule : How can I round the amount into integ... in Technology Q&A

Business Rule : How can I round the amount into integer number

Napat_Iamlaor — Mon, 02 Dec 2024 17:53:15 GMT

Hi Expert,

I have a business case in order to round the amount of Salary to integer number by using Business Rule in SuccessFactors to apply for this logic

for example case,

1. If employee has salary in ones position from 0.1 - 2.4 (Rank 1) they would like to round down to zero with no digit

For Example 1

1.1 If Employee has Salary 101,632.40 THB, They would like to show this amount as 101,630.00 THB

1.2 If Employee has Salary 101,632.35 THB, They would like to show this amount as 101,630.00 THB

2. If employee has salary in ones position from 2.5 - 7.4 (Rank 2) they would like to round to 5 with no digit

For Example2

2.1 If Employee has Salary 101,632.72 THB, They would like to show this amount as 101,635.00 THB

2.2 If Employee has Salary 101,635.50 THB, They would like to show this amount as 101,635.00 THB

2.3 Employee has Salary 101,637.20 THB, They would like to show this amount as 101,635.00 THB

3. If employee has salary in ones position from 7.5 (Rank 3) they would like to round to tens position with no digit

For Example 3

3.1. If Employee has Salary 101,637.50 THB, They would like to show this amount as 101,640.00 THB

3.2 If Employee has Salary 101,638.50 THB, They would like to show this amount as 101,640.00 THB

Thank you in advance

ArunSuresh3 — Tue, 25 Feb 2025 12:28:01 GMT

I think your requirement will be possible with look up table and business rule.

1. Create a look up in object definition to define the Minimum Range and Maximum Rage then round to defined number.

Example:- Minimum Range:- 101,629.40

Maximum Range:- 101,632.35

Round to:- 101,630.00 (Defined number)

2. Create business rule using Look up function to validate the salary amount and set the condition to round as per the look up value definition.

Note:- You have define the look up logic for all the number range.

Thanks & Regards

Arun

Alex_Monteverde — Wed, 17 Sep 2025 07:03:53 GMT

There are some examples of the combinations of precision and threshold you could use: