on 01-20-2020 10:58 AM
Hi Experts,
I have a difficult scenario to write the formula in Successfactors compensation.
1.When employee have the amount in onetime bonus(lumpSum), Bonus type (Spot Bonus/Retention Bonus) is mandatory.
If planner does not select this bonus type system should throw the error.
2. When employee does not have one time Bonus(lumpSum), Bonus type is None Selected.
for the above requirement i wrote the formula but it is not working.
if(CUST_BonusType='None Selected',"FALSE","TRUE")
Please provide valuable answers to finish this requirement.
Regards,
Lalitha
Hey Lalitha,
The "None Selected" option does not catch with custom validations. Instead, try writing this in the opposite logic to say if Lumpsum is selected TRUE else, FALSE. This will catch the None Selected as invalid and will work. You can compound these if there are multiple selections that are true by stringing the if statements in one another, as needed.
Hope this helps!
Kierstyn
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
4 | |
3 | |
3 | |
2 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.