Help with set analysis

[Anonymous]

I need help with the following expression -

Count({$<field={'NULL'}>}field)

However, I want it to do the opposite of this.  I want it to ignore the 'NULL'.  I tried replacing the '=' with '<>' but that didn't work.

Any suggestions?

Thanks

Greg

[sasiparupudi1]

or may be this

Count({$<field ={'*'}-{'NULL'}>}field)

[Peter_Cammaert]

I just reread your initial post. You know why = works in a set modifier, but <> doesn't? That's because the equal sign means 'temporarily assign the set of values on the right to the field on the left'. It's not a comparison operator, it's a (temporary) assignment that lasts for the duration of the expression calculation.

Just like the following is a valid script assignment

LET vField = 'ABC' & chr(10) & 'DEF';

but this one is not:

LET vField <> 'GHI';

[beck_bakytbek]

Hi Greg,

look at this: Flags in script

i hope that helps