Skip to Content
0

IFNULL operator in Graphical View

Apr 11, 2017 at 07:55 AM

87

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member Apr 13, 2017 at 07:20 PM
1

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello Mateusz,

Thanks a lot. This is what am looking for.

Regards,

Alfonso

0