Excluding fields in set analysis

[jmcdermott]

I have some warehouses and want to exclude 3 of them from my output, this is the formula I tried and it doesn't work

count({<trans_act= {'SHIP'},trans_obj={'OBO'},facility={'C'},whse -= {'CHIC','FCNC','CLMU'}>}lno)

I want to exclude CHIC, FCNC, and CLMU how do I do this?

Thanks,

Josh

[jmcdermott · Accepted solution]

Never mind the formula does work

[sunny_talwar]

Another option

Count({<trans_act = {'SHIP'}, trans_obj = {'OBO'},facility={'C'}, whse = e({<whse = {'CHIC','FCNC','CLMU'}>})>} lno)