Sum function false result

[dominicanlauf]

Hello everybody,

when I checked my QV calculation, one line turned out to be wrong. When I calculate the sum of "StckPlan" in Excel the result is 9480 - according to QV it is 2370.

Basically it is a very simple function (Sum(MPS_productionorder.amount)).

Has anyone ever had a similar problem and knows why it could be?

Thanks,

Dominic

[sunny_talwar]

Are the fields coming from different tables in the backend of the application? It seems that there is a many to many implicit join between fields from different tables which might be duplicating the sum when those fields are added, but not when you use the fields from a single table in the below table.

[dominicanlauf]

The application  consists of 40 tables, which come from two production planning systems.

The upper pivot table consists of 7 tables. At this point the informations are complete.

The lower table sums up the columns, ignoring some of the values.

I can not change anything about the structure of the data, which I get from the IT department. It should be possible to sum up the values anyway or not?

Dominic

[sunny_talwar · Accepted solution]

It definitely is, all you need to do is to do something like this

Sum(Aggr(Sum(StckPlan), Mat, Anlage, ok, gel))

[dominicanlauf]

Great, it works!

Thank you!