Successfactors BR:way to add "subtract only until the amount gets to 0" in the THEN: CREATE section?

[adriangalisteo]

Hello peers.

this question refers to a Successfactors business Rule case scenario.

I am trying to create a business rule that reduces the amount of a given pay component existing in the Recurring Payments Portlets according to a Vlookup table predefined quantity. The problem is that the mentioned amount decrese must not be negative.

The minimun amount allowed should be 0 for the pay component, never negative or it would be reducing the salary of the employee) and currently, as the rule is set up, it does subtract the amount to the pay component until a negative number. The current rule is as follows;

Is there any chance/way to add that "subtract only until the amount gets to 0" in the THEN: CREATE section?

(I know i could be doing something like that in the IF section but that would make me multiply the IFs when i have already plus than 20 IFS in this rule)

Thanks in advance

[nlgro023]

2 ways are thinkable:
- You can setup a variable in which you do the minus, then you have if statements that check if its >= 0 and deduct as normal there and 1 that goes below 0 and then the default deduction can then be 0.
- You could play around with CAP accrual (but in principle its actually more designed for time off and It may be tricky working with opposite signs etc. to achieve this requirement.

[adriangalisteo]

Hi jasper.de.groot Thanks so much for the prompt reply.

I tried the first option but i would have to do around 29 variables because i have 29 values and that means 29 ifs, i would rather not use the IF if there is a way to avoid it.

I was looking for something more like "Cap amount, cap result" so your Cap accrual looks interesting, however i thought that it was only working with Time off,would it work here?

If not, can you thing about any other option/feature within business rules that allows to create someting like an "internal if" inside of the Then Create?

Regards

[nlgro023]

I've not tried the balances feature, I know its roughly the only function that does something with a cap.
Based on your scenario I haven't seen something yet that would require it to be 29 variables, what would make that needed in your perspective (perhaps some efficiency can be thought of there)?

[adriangalisteo]

The thing is that i created a Lookup table MDF object, as the client needs to render their Seniority salary increase tables in the system. These tables have around 7 seniority levels each one, and at the time beign we have 3 tables (1 per every labor collective agreement) it is true that is not 29 but it is 21 and there will be more. The need to make the lookup table is because otherwise we would have to be adding the amount manually in each part of the Business Rule. Moreover, the quantity to be populated in the amount field for the concept and therefore in every variable will be 1 per every existing amount and as mentioned, there are 21.

If you can think about a way to create an "unique table" to get the amounts from without having to create a new vlookup object for every amount would be appreciated. However, for the moment is the way i,ve found.

Regards