SAP Knowledge Base Article - Preview

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

Symptom

  • 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.

 

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


Read more...

Environment

  • SAP SuccessFactors HXM Suite
  • SAP SuccessFactors Compensation

Product

SAP SuccessFactors Compensation all versions ; SAP SuccessFactors HXM 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 for Me (Login required).

Search for additional results

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