Sum TOTAL

[danielnevitt]

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

[lironbaram · Accepted solution]

hi 

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)