Formula Field , how to check for type number case if blank, if value is 0 if value >0

[kyrillos]

Formula Field , how to check for type number case if blank, if the value is 0 if value >0

sees the isBlank function not return true value in case of field type Number

[AlexP]

Hey @kyrillos ,
Can you be more specific on what you want to achieve?
For me isBlank works fine, it returns true in case of blank Number field.

[Alex]

Hey there, are you trying to check if a number > 0?

You can do this like this:

[kyrillos]

no i want to know whether is it blank or it has a value of zero

[Alex]

In that case you can do this:

[Alex]

I was also just told by @nigel that isblank(0) does resolve to true in the lastest release. If you self host you will have to upgrade to the latest Baserow version and your formula should work without a workaround.