case when field is blank write something else display value

Reply
Highlighted
Orange Belt

case when field is blank write something else display value

Have a field settlementID, I'm wanting to display when there isn't a value for that row to show pending else show the settlement id

 

something like when settlementID is blank then 'Pending' else settlementID

 

 

thank you


Accepted Solutions
Highlighted
Major Brown Belt

Re: case when field is blank write something else display value

How about something like

 

(CASE
WHEN `settlementID` IS NULL THEN IFNULL(`settlementID`,'pending')

ELSE `settlementID`
END
)

 

 

dojo help 3.JPG



**Make sure to like any users posts that helped you and accept the ones who solved your issue.**

View solution in original post


All Replies
Highlighted
Major Brown Belt

Re: case when field is blank write something else display value

How about something like

 

(CASE
WHEN `settlementID` IS NULL THEN IFNULL(`settlementID`,'pending')

ELSE `settlementID`
END
)

 

 

dojo help 3.JPG



**Make sure to like any users posts that helped you and accept the ones who solved your issue.**

View solution in original post

Highlighted
Orange Belt

Re: case when field is blank write something else display value

thank you

Announcements
Coming Soon: Weekly Virtual User Meet-ups to answer all your questions! Stay tuned for more details to come this week.