
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Thanks,
Dominic
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It definitely is, all you need to do is to do something like this
Sum(Aggr(Sum(StckPlan), Mat, Anlage, ok, gel))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It definitely is, all you need to do is to do something like this
Sum(Aggr(Sum(StckPlan), Mat, Anlage, ok, gel))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Great, it works!
Thank you!
