SAP Knowledge Base Article - Public

3522865 - The Greater Than relative selection from a report provides wrong values

Symptom

Within a report, you are filtering a field by Greater than 15, and the result wrongly shows 3.

Environment

  • SAP Cloud for Customer
  • SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Analytics work center.
  2. Go to Design Reports view.
  3. Open any report.
  4. Filter a field which is "Text" type by Greater than 15, and the result shows 3.

Cause

This field is supposed to show days, but it has been created as a text field. Since it is a text and not a number, any sorting or comparison will happen according to how numbers are treated when they're stored as texts. For texts, '3' will be greater '15' since ASCII value of 3 is greater than 1.

Resolution

For the comparison/filtering to work, you must store these texts as 03 instead of 3. A much better approach would be to create this extension field as a number, add it to the report as a key figure and then use the conditions feature to restrict the values.

Keywords

KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

Product

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