SAP Knowledge Base Article - Public

3648132 - Lookup field shows N/A when pmRating is used

Symptom

Values from a lookup formula are reflecting as N/A or catchall(wildcard) value in the form when lookup table has pmRating as input

Environment

  • SAP SuccessFactors Compensation
  • SAP SuccessFactors Variable Pay

Reproducing the Issue

  1. Create a lookup table with pmRating as one of the inputs
  2. configure a field in the Compensation template to lookup from the earlier created lookup table and have pmRating as one of the lookup input fields
  3. Launch a form
  4. Goto Executive Review or the compensation form
  5. Check the values in the field derived using lookup formula
  6. The value will be either N/A or a catchall(wildcard)value defined in the lookup table

Cause

This is a current system behavior

Resolution

Please be mindful of the datatype that you are using for the lookup formula field.

In the Lookup formula field, use toString formula within the lookup formula for pmRating field alone. An example is shown below.

lookup('Lookup table name',toString(pmRating),position of the output value in the lookuptable)

(lookup('2024_Bonus per rating table',toString(pmRating),1)

See Also

Designing the Worksheet

Keywords

lookup table,Lookup Formula, pmRating in lookup formula, Lookupvalue, N/A as output for lookup value , KBA , LOD-SF-CMP-FRM , Forms & Templates , How To

Product

SAP SuccessFactors HCM Core 2505