Calculation after agregation

42 Views

Helllo,

I want to get the summation of individual column values in the overall result column for a keyfigure. But we do not get the summation value for the CKF. Please see the details below:

This is a calculated keyfigure (CKF) and it is populated by the replacemant path variables.

The calculation for this keyfigure is as follows:

Net weight (Attribute of MATERIAL) * Actual GR qty (Attribute of PRODORDER).

Also, the checkbox is selected for "Calculation after Aggregation" in the aggregation tab of the query.

We feel that due to this checkbox,we are not able to get the overall result i.e. summation value in the result column.

So, we removed the selection of the checkbox. But now, we got the overall result correctly in the result column but the data in the individual columns is incorrect.

We also tried another option i.e. we created a formula instead of CKF but still the same problem exists.

Does anyone have any idea how to get the overall summation in the result column for the CKF?

Thanks and Regards,

Nitin Chopade.