Custom formula shows N/A in the form
source link: https://community.sap.com/t5/human-capital-management-q-a/custom-formula-shows-n-a-in-the-form/qaq-p/13680113
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
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.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK