How to add one more condition of OR in valueexpression of when using IF(ISBLANK.....)

[JerryWu]

Hello All, in text mode, I would like to add one more condition of OR relation into expression, see my valueexpression below, if my expression wrong, if someone can point me on this? thanks!

Textmode=true

displayname=Overall Status

IF(ISBLANK({DE:Confirm receipt QTY}) or ISBLANK({DE:Confirm receipt date}),"OPEN","CLOSE")

valueformat=HTML

When I used one condition (without OR), it is OK, so I guess my OR expression is wrong, need your help here! thanks!

[Dougplganger · Accepted solution]

#aacgotcha01

[JerryWu]

Thanks Dougplganger! another question, if I wanted to make this column result of "OPEN" and "CLOSE" as grouping, How can I do that by text mode?

 Below is what i made the grouping before by queueTopic:-

group.0.linkedname=convertedOpTask
group.0.namekey=Queue Topic Name
group.0.valuefield=convertedOpTask:queueTopic:name
group.0.valueformat=HTML
textmode=true

[Doug_Den_Hoed__AtAppStore]

Hi @JerryWu,

I invite you to try this syntax:

IF(ISBLANK({DE:Confirm receipt QTY}) || ISBLANK({DE:Confirm receipt date}),"OPEN","CLOSE")

Regards,

Doug 

[RandyRoberts]

To supplements Doug's solution, here's a cheatsheet you can keep on your desktop:

[JerryWu]

Wow, great cheatsheet, thanks for your generous sharing, Randy!