IFNULL operator in Graphical View

[Former Member]

Hello All,

I have a requirement to use a IFNULL operator in Graphical calculation view. I can use this operator in Scripted view but Graphical view doesn't support this keyword. Can anyone help me out in this?

Regards,

Alfonso

[Former Member · Accepted solution]

Hello,
I think you should use isnull instead of ifnull
Try this: IF(ISNULL("column_Name"),then,else)
or

IF(ISNULL("column_Name")=1,then,else)

Mateusz.

[Former Member · Accepted solution]

Hello Mateusz,

Thanks a lot. This is what am looking for.

Regards,

Alfonso