How To Fix BRAIN_DEV136 - The formula "&1"(&2) contains different exception aggregations: &3, &4

SAP Error Message - Details

• Message type: E = Error

• Message class: BRAIN_DEV - BRAIN messages (for use by development)

• Message number: 136

• Message text: The formula "&1"(&2) contains different exception aggregations: &3, &4

What causes this issue?

The formula or calculated key figure "&V1&" (&V2&) contains different
exception aggregations. The result of multiple exception aggregations
depends on the order in which the aggregations are executed, if the
exception aggregations are not the same. An execution order of
exceptions aggregations defined as a single formula or calculated key
figure cannot be guaranteed.

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?

Contact SAP support.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message BRAIN_DEV136 - The formula "&1"(&2) contains different exception aggregations: &3, &4 ?

  The SAP error message BRAIN_DEV136 indicates that there is an issue with a formula in a query or report that involves different exception aggregations. This typically occurs in the context of SAP BW (Business Warehouse) or SAP BI (Business Intelligence) when you are trying to create or modify a query that uses multiple exception aggregations that are not compatible with each other.
  
  Cause:
  The error arises when the formula you are trying to use contains different exception aggregations that cannot be combined. Exception aggregations are special calculations that allow you to define how certain values should be aggregated differently from the standard aggregation methods. For example, you might have a formula that tries to aggregate sales data using both "SUM" and "AVERAGE" for different components, which is not allowed.
  
  Solution:
  To resolve this error, you can take the following steps:
  
  
  Review the Formula: Check the formula mentioned in the error message. Look for any exception