Skip to main content

Announcements
Week 3: High-Volume Iceberg Ingestion and Smarter Data Prep - WATCH NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dominicanlauf
Contributor III

Sum function false result

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?

 

SummeFalsch.PNG

Thanks,

Dominic

1 Solution

Accepted Solutions
sunny_talwar

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

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

 

View solution in original post

4 Replies
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
Contributor III
Author

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

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

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

 

dominicanlauf
Contributor III
Author

Great, it works!

 

Thank you!