SAP Knowledge Base Article - Public

3679717 - It's not possible to perform an operation in Advanced KPIs using Formulas

Symptom

Error occurs when attempting to perform multiplication or division operations with operations such as (<, <=, >, >=, ==, !=, AND, OR.) on Engagement Maps

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to Activity Plan Work Center
  2. Open the Engagement Maps View
  3. Open the Engagement Map where is the KPI
  4. Go to KIPs facet 
  5. Open the KPI 
  6. Under Formula Editor create a formula using multiplication after a operator like <, <=, >, >=, ==, !=, AND, OR.

Cause

Operators (<, <=, >, >=, ==, !=, AND, OR) return Boolean values (True = 1, False = 0) instead of numeric values. These Boolean values cannot be directly used for multiplication or division operations within the formula.

Resolution

  • Adjust the formula to ensure that numeric values are derived before performing multiplication or division operations.
  • Replace the Boolean results generated by the operators with appropriate numeric values or conditions that can be utilized in arithmetic calculations.

See Also

Help SAP Portal : Operators in Advanced KPIs

 

Keywords

advanced KPIs, Boolean values, operators, formula adjustment, KPI calculation, multiplication error, division error, numeric values, SAP Help documentation, Opportunity Management , KBA , LOD-CRM-OPP , Opportunity Management , Problem

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions