Forum Discussion
lp
3 years agoNew Contributor III
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!
A#NET_INCOME.Base.Where(Text2 <> '')
3 Replies
- NidhiMangtaniContributor III
Please try this:
A#NET_INCOME.Base.Where(Text2 is empty)
- EricOsmanski
OneStream Employee
A#NET_INCOME.Base.Where(Text2 <> '')
- lpNew Contributor III
A#NET_INCOME.Base.Where(Text2 <> '') worked – thanks so much!
Related Content
- 3 years ago