SAP Knowledge Base Article - Preview

2084142 - Manage Data - Calculations - Using toNumber Function to Prevent N/A Result - Compensation

Symptom

All Images From Demo Instance

  • You have a field which uses a lookup table value. In this example we are using "Parking Allowance".
  • This field is also used within a calculation of another field. In this example we are using "Say Extra Parking Allowance".
  • The correct data is populating within field "Parking Allowance field" however "Extra Parking allowance" is showing N/A.

          example formula.jpg

          N A Values in Worksheet.jpg

  •  Per the above configuration if “Parking Allowance” is <2000 then “Extra Parking Allowance” should this should return 10% of Parking Allowance, however we instead see N/A.

Read more...

Environment

  • Compensation

Product

SAP SuccessFactors Compensation all versions ; SAP SuccessFactors HCM Core all versions

Keywords

lookup tables, custom forumlas, compensation lookup, N/A values, CompaRatio, Range Penetration, Compa , KBA , sf compensation calculations , LOD-SF-CMP , Compensation Management , LOD-SF-VRP , Variable Pay Programs , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.