formula, !isnull

[wonka1234]

Hi,

How do I create a formula (same column) to get the !notnull values.

!IsNull(([Mainframe_ACF2]))  I am trying this but getting values of 0 and -1.

Thanks

[Qizhan]

@KrishnaChithrathil thank you so much

[DenisZ]

If you want to mark not null columns with for example 1, then use the formula tool and call it IF isNull([Field1]) THEN 1 else 0 ENDIF. 

Hope this helps