Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have expression as below. I have to compare if the status is null. How can I make.
=if(Id<>1,date(StatusDate), if(Status='Status1', 'ST1',if(Status is null, 'BLANK',date(StatusDate))))
It is giving expression error. If my status field no value I want to show'BLANK'.
Thanks..
len(trim(Status))>0 not null
You can use "IsNull(Status)"
Regards,
Gabriel