SAP Knowledge Base Article - Public

3650692 - Incorrect Amount Sign Display in Custom Analytical Query Report Preview

Symptom

In the preview of the custom analytical query report, amounts are displayed with the wrong sign.

Environment

SAP S/4HANA Cloud Public Edition

Cause

Query report preview framework is based on the annotations that are defined in the analytical CDS view, If the field is not defined as a measure, it will be considered a dimension, and the properties of the numeric field won't be taken into account.

Resolution

To use any "field" as a key figure in the Query Report, the aggregation for the "field" must be defined in the corresponding CDS View.

Open the CDS View and set the aggregation accordingly.

Keywords

Negative sign, Custom analytical query report, CDS view, aggregation, analytical query, Fiori query designer, tax reporting, incorrect report evaluation, Incorrect Amount Sign Display in Custom Analytical Query Report Preview , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem

Product

SAP S/4HANA Cloud Public Edition all versions