Aggregate Function giving scaled up values

[#1]

I have a table as follows:

And when I apply the aggregate function on duration as aggr(sum(DURATION),SYSTEM_ID)  , I get the values totally scaled up.. I noticed they are multiplied 7 or 6 or 5  times than the expected values what could be the reason, the aggregated table is as follows:

[hic]

You should not use the Aggr() function like that. Change your expression to Sum(DURATION) only, and see what you get.

See also http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/11/when-should-the-aggr-function-not-be-u...

HIC