Set Analysis for 2 Conditions

[#1]

I'm trying to create a sum calculation based on a field (NC) not equalling certain criteria ("1200,2100,2150 .......") and field (F4) = "PI"

I've managed to get the 1st criteria to work using the expression below but I'm not sure how to include the AND F4 = "PI" bit

Sum({$<NC-={"1200","2100","2150","2201",

"2202","2011","2012","2013","0011","0012","0013","0020","0021","0030",

"0040","0031","0041","0045","0046","1001","1010","1235","1230","1240",

"1250","2200","3200","4001","1102","4010","1110","2101","2102","2301",

"2310","2320","2325","3000","4013","4021","4022","4035","4030","4900",

"4902","4903"}>}CR)

Any ideas please, I've tried what I thought but just keep getting 'Error in Expression' messages whenever i try anything

[sunny_talwar]

May be like this:

Sum({$<NC-={"1200","2100","2150","2201",

"2202","2011","2012","2013","0011","0012","0013","0020","0021","0030",

"0040","0031","0041","0045","0046","1001","1010","1235","1230","1240",

"1250","2200","3200","4001","1102","4010","1110","2101","2102","2301",

"2310","2320","2325","3000","4013","4021","4022","4035","4030","4900",

"4902","4903"}, F4 = {'PI'}>}CR)

[tresesco]

Try like:

Sum({$<NC-={"1200","2100","2150","2201",

"2202","2011","2012","2013","0011","0012","0013","0020","0021","0030",

"0040","0031","0041","0045","0046","1001","1010","1235","1230","1240",

"1250","2200","3200","4001","1102","4010","1110","2101","2102","2301",

"2310","2320","2325","3000","4013","4021","4022","4035","4030","4900",

"4902","4903"} , F4={PI}>}CR)

And yes, you can remove the double quotes around the numbers.

[#4]

Thanks guys, really appreciate your help. I just couldn't figure out how to write it.

[sunny_talwar]

It is still not working?