Solved

Checking for Null / empty value in Calculation Formula

  • 19 January 2024
  • 1 reply
  • 41 views

Badge +2

Hi,

I’m working with Calculation Formulas and need to check against calculation fields if they’re empty.

I’ve tried to check for

= ‘’

= ‘!%’

<> ‘%’

and only an equal sign without defining a value (= )

None of these options work. Does anybody know how you can search for it? Thanks!

 

icon

Best answer by VWagner 19 January 2024, 14:24

View original

1 reply

Badge +2

And now I’ve got it…

To search against empty values use = ‘NULL’

Reply