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
SAP Knowledge Base Article - Public