Skip to main content
Newcomer
September 12, 2022
Solved

Where Text Field is not Blank

  • September 12, 2022
  • 2 replies
  • 0 views

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 <> '')

2 replies

Veteran
September 13, 2022

Please try this:

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

OneStream Employee
September 13, 2022

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

lp2Author
Newcomer
October 13, 2022

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