SAP Knowledge Base Article - Public

3718586 - Error "Function SUMGT is unknown" in Custom Analytical Queries and Services in S/4 HANA Public Cloud

Symptom

An error occurs when attempting to use the SUMGT function in a calculated measure within the new Custom Analytical Queries and Service app.


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

Environment

SAP S/4HANA Cloud Public Edition

Reproducing the Issue

  1. Go to "Custom Analytical Queries and Service" app.
  2. Try to create a custom query
  3. Attempt to use the SUMGT function to calculate the grand total of a row.
  4. Observe the error stating the function does not exist.

Cause

This is the default system behavior; the Custom Analytical Queries and Services app does not allow the use of the SUMGT function in calculated measures. 

Resolution

  1. In "Custom Analytical Queries and Services", replace the SUM function with GRAND_TOTAL. Ensure that GRAND_TOTAL is used with named parameters.
  2. To check for the allowed functions, click on the button 'allowed'

See Also

Refer to: Adding Measures | SAP Help Portal

Keywords

sum function, custom analytical queries, grand total, sap s/4hana cloud public edition, analytical queries app, calculated measure, sumrt, non-numerical values, named parameters, custom cds views, aggregation error, query designer, fiori , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem

Product

SAP S/4HANA Cloud Public Edition all versions