Add the Default Value of Custom Column in Compensation Custom Column Formula

[careng_sun]

Hi Good day!

In our Compensation we have two Custom Columns for promotion:

Recom for Promotion : Column 1 > lookup table

Final Promotion override : Manager's input with Yes or No options. There is no default value

Now I am creating this formula:

if (Recom for Promotion="Yes" && Final Promotion override="Default Value",customFieldx,

if (Recom for Promotion="Yes" && Final Promotion override="Yes",customFieldx,

if (Recom for Promotion="Yes" && Final Promotion override="No",0,

if (Recom for Promotion="No" && Final Promotion override="Yes",customFieldx,0))))

I am having issue with the first line, where in when Recom for Promotion = Yes and there is no input on Final Promotion override, it should show the customFieldx.

The rest of the if conditions are working fine except for the first line. It requires to select on the Final Promotion override.

What I am trying to do is, when Recom for Promotion is equal to Yes and no input or Manager does not need to select anything on Final Promotion override, it should show the customFieldx.

I have tried these:

1. if (Recom for Promotion="Yes" && Final Promotion override="Default Value",customFieldx

2. if (Recom for Promotion="Yes" && Final Promotion override=" ",customFieldx

3. if (Recom for Promotion="Yes",customFieldx > this option is having issue with the 3rd line above.

4. if (Recom for Promotion="Yes" && Final Promotion override="null",customFieldx

5. if (Recom for Promotion="Yes" && Final Promotion override="None Selected",customFieldx

I also tried adding default value , space and words None Selected but it still doing the same behavior.

Any help is much appreciated. Thank you so much!

[xavierlegarrec]

Hi carengskii

A quick way to fix your issue is to make Final Promotion override field be "No" by default instead of Blank.

but if customer insists on having it blank by default, then your best option for your formula is #2 but without the space in the quotation marks :

2. if (Recom for Promotion="Yes" && Final Promotion override="",customFieldx

In case you are a partner consultant, please ask your questions on the Partner Delivery Community :

https://partnercommunity.successfactors.com/t5/Compensation-Management/bd-p/Compensation-Management

Thank you !

Xavier