Sum absolute volume by field

danielnevitt — Wed, 27 Apr 2022 12:49:57 GMT

Hi,

I'm trying to create a field in the load script to calculate the sum of the absolute position volume (abs_pos_vol) by trade number (hdr_num).

I thought the solution would be either of the following, however this returns an erro:

Sum(aggr(sum(DISTINCT atr.abs_pos_vol),hdr_num)) as abs_pos_vol_distinct,
Sum(DISTINCT atr.abs_pos_vol),hdr_num)) as abs_pos_vol_distinct;

Any help would be much appreciated.

Regards,
Daniel

Re: Sum absolute volume by field

pooja_prabhu_n — Wed, 27 Apr 2022 13:52:00 GMT

Hi,

We can not use Aggr() function in load script, you can try that expression in front end.

In load script you can try group by

sum(DISTINCT atr.abs_pos_vol) as abs_pos_vol_distinct

group by hdr_num;

what is the error that you are getting when trying to calculate the sum?