Skip to main content
Member
Sep 12, 2022 9:10 PM UTC
Solved

Where Text Field is not Blank

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!

Employee - Mentor
Sep 13, 2022 11:42 AM UTC

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

3 replies

Veteran
Sep 13, 2022 6:44 AM UTC

Please try this:

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

Employee - Mentor
Sep 13, 2022 11:42 AM UTC

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

lp2Author
Member
Oct 13, 2022 8:22 PM UTC

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