SAP Knowledge Base Article - Public

3503116 - Variable Pay Offline Edit Does Not Update Formulas Based on Other Fields

Symptom

When updating fields with formulas based on other fields using the Executive Review offline edit, changes will only be maintained in the specific rows that were edited and the rest of the rows will be blank.

For example, you have the following configuration:

  • Custom field A (CFA) is an editable field
  • Custom field B (CFB) is a read only field
  • Custom field C (CFC) is a read only field with formula if(CFA='',CFB,CFA)

CFC is not updating based on changes made to CFB, even though CFB is included in the formula.

Environment

SAP SuccessFactors Variable Pay

Reproducing the Issue

  1. Log in to SuccessFactors
  2. Navigate to Compensation > Executive Review > Select plan.
  3. Rows for CFA are all blank. CFB and CFC will show the value of CFA.
  4. Export > select option to edit
  5. Make changes to CFA for a few employees.
  6. Save > Import
  7. Export the file again
  8. The CFC values only updated for the few employees with edits. All other employees show empty CFC values.

Resolution

Product Engineering is investigating a solution.

Click on star to bookmark this article to receive updates about this issue. For more information about updates from subscribed KBAs, you can refer to the KB Article 2171560 - How to be notified of new or updated SAP Notes or KBAs.

Workaround

  • For CFC, change the formula to if(CFA=''||CFA='NA',CFB,CFA)
  • If using offline edit, select NA if the user entry needs to be imported

See Also

Keywords

SAP Success Factors, Compensation, Executive Review, Filters, Export, Company Assignment, Update Company Assignment, ER Filter, ER Export, Blank Values, Incorrect Values, KI2405, VRP-14634 , KBA , LOD-SF-VRP-EXR , Executive Review , LOD-SF-VRP-REP , Reporting & Analytics, Data Imports & Exports , Bug Filed

Product

SAP SuccessFactors Compensation 2405