Expand my Community achievements bar.

SOLVED

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

Avatar

Level 3

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!

1 Accepted Solution

Avatar

Correct answer by
Level 2
5 Replies

Avatar

Correct answer by
Level 2

#aacgotcha01

Avatar

Level 3

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

Avatar

Community Advisor

Hi @JerryWu,

 

I invite you to try this syntax:

 

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

 

Regards,

Doug 

Avatar

Community Advisor

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

ScreenShot 2023-12-20 at 11.45.29 am.jpg

Avatar

Level 3

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