Sum TOTAL

danielnevitt — Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

I would appreciate some help with the below.

I have the following: expression =Sum({<trade_type_group_cd='Future'}>}abs_pos_vol)/Sum(TOTAL<trade_dt_weekname>abs_pos_vol)

How can I include the {<trade_type_group_cd='Future'} in the Sum(TOTAL part of the expression?

Thanks,

Daniel

Re: Sum TOTAL

lironbaram — Tue, 10 Mar 2020 13:13:20 GMT

this should work for you

=Sum({<trade_type_group_cd='Future'}>}abs_pos_vol)/Sum({<trade_type_group_cd='Future'}>}TOTAL<trade_dt_weekname>abs_pos_vol)