a NOT Equal on several types

[troop49]

I have several funds i need to display on the report but
i have certain one i DO NOT want to include on the report.

expression:
@fund <> "520""610""648""691"


how can i exclude them with out doing

@fund <> "520" and @fund <> "610" and etc.....



I know there has to be a way.

Thanks,

 

[lbass]

not({@fund} in ["520","610","648","691"])

This would work unless you have codes like "52", "61", etc. that technically ARE in "520","610".

-LB

 

[Flowers08]

try not (field name) in["",""]