Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Never mind the formula does work
Never mind the formula does work
Another option
Count({<trans_act = {'SHIP'}, trans_obj = {'OBO'},facility={'C'}, whse = e({<whse = {'CHIC','FCNC','CLMU'}>})>} lno)