09-12-2022 05:10 PM - last edited on 05-23-2023 11:08 AM by JackLacava
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!
Solved! Go to Solution.
09-13-2022 07:42 AM
A#NET_INCOME.Base.Where(Text2 <> '')
09-13-2022 02:44 AM
Please try this:
A#NET_INCOME.Base.Where(Text2 is empty)
09-13-2022 07:42 AM
A#NET_INCOME.Base.Where(Text2 <> '')
10-13-2022 04:22 PM
A#NET_INCOME.Base.Where(Text2 <> '') worked – thanks so much!