Expression help

[danielnevitt]

Hi,

I have the following expression and I would like to include where the hdr_num is DISTINCT.  Is this possible?

Thanks,

Daniel

Fabs(sum(if(trade_type_name='APO' and opt_pc_name='Put',(opt_strike_price)*payment_qty, if(trade_type_name='APO' and opt_pc_name='Call',(-opt_strike_price)*payment_qty))))

[tamilarasu · Accepted solution]

Daniel

You can try below expression,

If(opt_pc_name = 'Put', Sum(Aggr(sum(DISTINCT{<opt_pc_name={`Put`}>}opt_strike_price*payment_qty),hdr_num)),

Sum(Aggr(sum(DISTINCT{<opt_pc_name={`Call`}>}opt_strike_price*-payment_qty),hdr_num)) )

[Anil_Babu_Samineni]

Hi,

It depends what you want to achive by combining. If you need an arthemetic operation between Set 1 and 2 then can directly join them. If you want set 1 and set 2 to made for union/intersection or any other "set theory" operations, QV support them thru set analysis operators. You can read about them more in QV help (Section "Set Operators" in "set analysis")

Might be helpful meantime try with 2 variables and let me know.

- Anil

[danielnevitt]

Hi Tamil,

That expression seems to work.  Thanks for your help.

Regards,

Daniel

[tamilarasu]

No Problem. Have a nice day.