2084135 - Managing Data, Custom Calculations / Formulas and Functions - CMP & VRP

This KB article provides detailed information for users attempting to build their own calculations within Compensation & Variable Pay.

Note:

• Support is typically unable to troubleshoot any custom calculations (formula) when these are either broken or you are unable to create a valid calculation.
• Calculations are by nature complex and unique to your plan and should be developed with assistance from a paid partner or professional services engagement.
• If you do encounter calculation issues with custom formulas etc we would recommend the formula to be broken down. This will identify the potential problem.
• If the field is presenting one of the below scenarios, it means that the custom formula created is not entirely correct, like missing a function or using additional functions that are not required. If that is the case, implementation partner or professional services must be engaged to verify.
1. The worksheet is launched and the field is displayed as N/A but populated once any change is made to the form.
2. The worksheet is launched and the field is correctly populated, but switches to N/A once any change is made to the form.
• If you are not following the best practices recommended, your calculations (formulas) may behave with inconsistencies.
• It's not recommended to use formulas with blank values in between ' ' or " ". The best practice is to have a value between the quotation marks.

Important:

• When creating formulas please note it is NOT recommended to have more than 10-15 conditions when using the IF, THEN or ELSE syntax.
• If this is something you are looking to implemement we suggest using a lookup table.
• Attached to this KB article is an example of a custom formula using the IF syntax, which is not recommended.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP SuccessFactors Compensation
• SAP SuccessFactors Variable Pay

custom formulas, compensation formulas, calculations, formulas, complex formulas, manage data, managing data, lookup tables, sf, success factors,formula inconsistency, tables, , KBA , sf compensation manage data , LOD-SF-CMP-ADM , Admin Tools, Settings, Permissions , LOD-SF-VRP-ADM , Admin Tools, Settings, Permissions , How To