Set analysis not equal

[#1]

Hi Guy's

I am trying to use the following set analysis but cant seem to get it right.

sum({<[Lab Authorisation Type]= {'1'}, [Grower ID] -= {'77'}, [Grower ID] -= {'99'}, [Grower ID] -= {'100'}, [Grower ID] -= {'111'}>} [Delivery DIS Mass Adjusted])

[swuehl · Accepted solution]

Only use one set modifier per field within a <....> pair.

sum({<[Lab Authorisation Type]= {'1'}, [Grower ID] -= {'77','99','100','111'} >} [Delivery DIS Mass Adjusted])