Exclude Filter

[paulwalker]

HI Community,

Facing issue with exclude selection, problem is same field using in aggregation.

I have to exclude CO selection, but if i give CO= not working - because same field in Aggregation.

Can you please help me..

NUM(AVG(AGGR((AVG({< GENDER={'M'}>}SALARY)-AVG({< GENDER={'F'}>}SALARY))
/
AVG({< GENDER={'M'}>}SALARY), CO, MUPC_CODE)),'##.#%')

Please note this expression using in textbox.

Thanks in Advance!!

[tresesco]

@paulwalker 

You can try putting the set component in aggr() and outer avg() as well like:

NUM(AVG( {<CO>} AGGR( {<CO>}(AVG(..

[MayilVahanan · Accepted solution]

Hi @paulwalker 

Try like below

NUM(AVG({<CO=>}AGGR((AVG({< GENDER={'M'},CO=>}SALARY)-AVG({< GENDER={'F'},CO=>}SALARY))
/
AVG({< GENDER={'M'},CO=>}SALARY), CO, MUPC_CODE)),'##.#%')