Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))))
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)) )
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
Hi Tamil,
That expression seems to work. Thanks for your help.
Regards,
Daniel
No Problem. Have a nice day.