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: