Skip to main content
Newcomer
September 12, 2022
Solved

Where Text Field is not Blank

  • September 12, 2022
  • 3 replies
  • 1 view

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!

Best answer by EricOsmanski

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

3 replies

Veteran
September 13, 2022

Please try this:

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

Mentor
September 13, 2022

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

lp2Author
Newcomer
October 13, 2022

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