replacing if statement with set analyisis

[#1]

hi all,

Can anyone help me out to replace these following 'if' statements with set analysis method please.

if([Fee type] = 'Contract Price', sum({<[Base Index]={'FIXED CASH'}, [Fixed/Index Price]={'FIXED','INDEX'}>}[Nominal Quantity])*-1,[Nominal Quantity]*-1)

if([Buy/Sell]='BUY',(( sum({<[Buy/Sell]={'BUY'}, [Base Index]={'FIXED CASH'}, [Fixed/Index Price]={'FIXED','INDEX'}, Location -= {'MET COAL','API5'}>}[Nominal Quantity])/1000)*-1)+

( sum({<[Buy/Sell]={'BUY'}, [Base Index]={'FIXED CASH'}, [Fixed/Index Price]={'FIXED','INDEX'}, Location = {'MET COAL','API5'}>}[Nominal Quantity])/500)*-1)

[#2]

can someone please help me out with this??

[#3]

Hi Sahana,

Can u attach sample file so it would be simple for community to make changes and post back

Thanks,

Prakash

[#4]

Hi Prakash,

I have attached a test application with the same 2 exp A and B.Can you help me out now buy replacing this expression in set analysis to obtain the same result.