aggregate function problem

[#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:

[maxgro]

could you post your doc?

Preparing examples for Upload - Reduction and Data Scrambling

[#3]

I have seen this in a few cases where there are duplicates.

Just try sum(aggr(sum(distinct DURATION),SYSTEM_ID)). This is not a solution but can help identify if there are duplicates in your model.

Thanks

AJ