Creating flags

[nareshthavidishetty]

Hi ,

The field consists both values and nulls.I need to create flags if values were there as flag1 and for nulls flag2.

Thanks..

[arulsettu]

maybe like this

if(field>0,'flag1','flag2')

[vinieme12]

to take care of enter characters or spaces that are not really null use trim()

if(len(Trim(Field))<1,'Flag2','Flag1') as FLAGfield

[Anonymous]

I have 2 suggestion:

=if(IsNull(Amount)=-1,'Flag2','Flag1')

or

=if(IsNull(Amount)>=0,'Flag1','Flag2')