How To Fix BRAIN_DEV141 - La fórmula &1 con variable &2 no puede calcularse antes de la agregación

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 141

• Message text: La fórmula &1 con variable &2 no puede calcularse antes de la agregación

¿Qué causa este problema?

The formula or calculated key figure "&V1&" contains the variable "&V2&"
and at least one non-cumulative key figure.
The variable "&V2&" is a variable with replacement path from a
characteristic attribute that is replaced before aggregation. In general
the order of calculation here is the following:
generic aggregation of non-cumulative key figure
exception aggregation of non-cumulative key figure
lookup of replacement path variable value and formula calculation
exception aggregation via the replacement path characteristic (Note
1385580 describes which aggregation is used here).
According to the settings of the variable "&V1&", the formula "&V1&"
should be calculated before the non-cumulative exception aggregation.
This is only possible if the formula is a commutative formula, that
means it can be calculated before or after aggregation Summation[SUM]
with the same result, and if there is no aggregation via the replacement
path characteristic explicitly defined in the formula.
But the formula "&V1&" is not a commutative formula. Therefore it is not
possible to calculate the formula before the non-cumulative exception
aggregation

Respuesta del sistema

An implicit exception aggregation via the replacement path
characteristic is applied according to Note 1385580 and the formula is
calculated after non-cumulative exception aggregation.

¿Cómo arreglar este error?

Ensure that the flag "Calculation of Commutative Formulas After
Aggregation" is not set to true in the query properties and the switch
(see Notes 2094114 and 1668991) FAGGR_BEFORE is not set to false. If the
formula is still calculated after aggregation, then the formula needs to
be remodeled.

Procedimiento para Administradoras de Sistemas

El sistema emite un mensaje de error y no le permitirá continuar con esta transacción hasta que se resuelva el error.

Extracto de mensaje de error del sistema SAP. Copyright SAP SE.