Symptom
Environment
SAP SuccessFactors Compensation
Cause
Standard percent fields are calculated on the fly and not stored in the database, that is why only the amount can be seen.
Resolution
NOTE: The solution mentioned below applies only if you have NOT yet launched the forms, as the solution requires adding custom column in the form template.
It is the sole responsibility of the customers to verify that the formula mentioned in this article is calculating the percentages correctly or not. Creating custom formula is outside of the scope of the CS team.
- Go to Compensation Home.
- Select your plan / template.
- Go to Design Worksheet > Design Worksheet
- Add a custom column (say Merit %).
- Select the below mentioned parameters as:
- Read-only: Yes
- Column Type: Percent
- Formula: merit/curSalary
- Hide this column on the form: Unchecked for now (This will allow you to check if % are calculated correctly)
- Reportable: Checked
6. Once this is done, Click Save.
7. Launch a new Form to verify if the percentages in this custom column are calculating correctly. As shown in the image below the system % and your custom column should now display the same values if configured correctly.
8. Once you verified that the percentages are calculated correctly, delete this test form and go back to design worksheet and check mark following two options:
- Hide this column on the form
- Exportable hidden column
9. Now you’ll be able to see this field in the statement editor and can add it to your statement, and would be able to print the merit increase %.
Keywords
merit %, merit percent, percent, statement %, statement , KBA , sf compensation statements , LOD-SF-CMP-PS , Personal Statements , How To