Custom formula shows N/A in the form

[xuanying]

Hi all,

A question about compensation custom formula shows N/A in the form. We'd like to use custom fields to show Segment for corresponding CR%andPIR%, for example, for CR% = 10%, it should show 0%-25%. However, the segment do not show by default for some fields now, and those are not shown by default would appear again when I edit the merit increment.

Current formula:

if(cust_CurrentCR<60,'Below 60%',if(cust_CurrentCR>=60&&cust_CurrentCR<70,'60% -70%',if(cust_CurrentCR>=70&&cust_CurrentCR<80,'70%-80%',if(cust_CurrentCR>=80&&cust_CurrentCR<90,'80%-90%',if(cust_CurrentCR>=90&&cust_CurrentCR<100,'90%-100%',if(cust_CurrentCR>=100&&cust_CurrentCR<110,'100%-110%',if(cust_CurrentCR>=110&&cust_CurrentCR<120,'110%-120%',if(cust_CurrentCR>=120&&cust_CurrentCR<130,'120%-130%',if(cust_CurrentCR>=130,'Above Max')))))))))

Really appreciate if anyone can provide some suggestion.

SAP SuccessFactors Compensation 

[catmoye]

Hi @xuanying, I would start by adding an "else" statement to your last "if", as formulas can behaves weirdly if the ifs do not all have an else

[catmoye · Accepted solution]

Hi @xuanying, I would start by adding an "else" statement to your last "if", as formulas can behaves weirdly if the ifs do not all have an else

[pmacgovern · Accepted solution]

This is exactly right. There is no "else" condition in your last if.

[xuanying · Accepted solution]

It works! Thank you 🙂