SuccessFactors Variable Pay Override zero

[annezijlmans2]

Hi all!

Our customers want to use the override in variable pay. In the override, they should also be able to enter 0 (so that even though person had bonus calculaton of for example 500 EUR, we can override to 0 EUR).

For one client I am succeeding with below formula, but for another client the same formula simply doens't work. When we put in 0 EUR for override, the bonus calculated amount stays.

formula: if(override=",finalpayout,override)

Does anybody have any ideas on this? Other solutions maybe?

[Former Member]

The problem with numeric fields is they all start with a value of 0, so there is no way to check to see if the user intended to put in 0 or hasn't bothered to put anything. There are three possible solutions:

1. If an award of zero is intended, make the user put in a negative number. Then your formula is "if(override<0,0,if(override>0,override,finalPayout))" this is the easiest and what I tend to do, but does put a training effort on the client.
2. Add a second field that is a drop-down called "Intentional Zero" with two values - no (the default) and yes. Then your formula is "if(override>0,override,if(override=0&&intentionalZero='yes',0,finalPayout))"
3. Make the override column a string type rather than a number. Then your formula works (but really should be "if(override='',finalPayout,toNumber(override))"), but this has the downside of someone accidentally putting non-numeric columns in there.

The decision may come down to how many people can use the override. If the number is very small, less hand-holding is needed and 1 or 3 are ok. If it is large, then I would recommend 2.

[xavierlegarrec]

Hi annezijlmans marliere

There is a blog on this topic here: https://blogs.sap.com/2023/03/11/building-an-override-from-a-lookup-table-with-0-as-an-accepted-valu... although in my business case the requirement was to have Comp Admin override with 0 from a lookup table.

All the best

Xavier

[annezijlmans2]

Thank you both! The weird thing is that the formula I provided is working for one of our customers. There, the override field is custom, but money. That is why I thought it should be possible somehow!

[emiliemarlier]

Hello,

I can share with you a feedback because we had the same issue on last campaign (it seems it is an SAP configuration, probably you can open an enhancement to evolve it. I will be a pleasure to vote to support it !) - and we decided for our next reviews to deploy the solution 2 proposed by Philip. Our column is hidden and by default, all employees have "yes" value = eligibles. Each Local Admin have permission to export worksheets and import them with a value No for employees related and like that, Final Payout will be automatically change by 0 even proposals are not 0.

Only painpoint, we ask to our managers to add a mandatory comment if the override is used. By import, we cannot import comments in the comment box tied to it. Comments can be only import are in "notes" comment box near employee name. It is not perfect but at least we can explain why in case of internal audit an eligible employee don't receive any payout.

Emilie