Where Text Field is not Blank

lp
New Contributor II

Hello,

I am trying to write a rule where I get the base of Net Income where the Text 2 field is not blank. Does anyone know the syntax to indicate blank?

 A#NET_INCOME.Base.Where(Text2 <> ????)

 

Thanks!

1 ACCEPTED SOLUTION

EricOsmanski
Valued Contributor

 A#NET_INCOME.Base.Where(Text2 <> '')

View solution in original post

3 REPLIES 3

NidhiMangtani
Contributor III

Please try this:

A#NET_INCOME.Base.Where(Text2 is empty)

Thanks,
Nidhi Mangtani

EricOsmanski
Valued Contributor

 A#NET_INCOME.Base.Where(Text2 <> '')

lp
New Contributor II

A#NET_INCOME.Base.Where(Text2 <> '')  worked – thanks so much!