Exclude Selection using set

[sivarajs]

Hi,

I am using set to exclude some fields selection but its not working. My expression is like

Avg({$<A,B>}if(D ='Service' and C > aggr(NODISTINCT fractile(C, 0.05), A) and C< aggr(NODISTINCT fractile(C, 0.95), A),C))

I f i select A its getting changed

Regards,

Sivaraj

[deepakk]

HI Sivaraj,

Try this code

Avg({$<A=,B=>}if(D ='Service' and C > aggr(NODISTINCT fractile(C, 0.05), A) and C< aggr(NODISTINCT fractile(C, 0.95), A),C))

Deepak

[sivarajs]

i have already tried that but it didn't work