How To Fix FDT_EXPRESSIONS754 - Aggregation column specified without an aggregation operation

FDT_EXPRESSIONS754 - Overview

• Message type: E = Error

• Message class: FDT_EXPRESSIONS - Formula & Derivation Tool: Expressions

• Message number: 754

• Message text: Aggregation column specified without an aggregation operation

What causes this issue?

An aggregation column has been defined for the current table, but the
operation type is either undefined or an operation other than
aggregation (for example, sum).

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Correct the definition of the table operation either by setting the
operation type to 'aggregation' or by removing the aggregation column.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

FDT_EXPRESSIONS754 - Details

• The SAP error message FDT_EXPRESSIONS754 indicates that there is an issue with the way an aggregation column is being used in a formula or expression within the SAP system, particularly in the context of SAP Fiori or SAP BW (Business Warehouse) reporting. This error typically arises when an aggregation column is specified without a corresponding aggregation operation, which is necessary for the system to process the data correctly.
  
  Cause:
  The error occurs due to one of the following reasons:
  
  Missing Aggregation Function: An aggregation column (like SUM, AVG, COUNT, etc.) is referenced in a calculation or expression without applying an aggregation function to it.
  Incorrect Expression Syntax: The syntax used in the expression may not be correct, leading to the system not recognizing how to handle the aggregation.
  Data Model Issues: There may be issues with the underlying data model or the way the data is structured, which could lead to confusion in how aggregations