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

Find more posts tagged with

Accepted answers

guitarhero23

How about something like

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

ELSE `settlementID`
END
)

dojo help 3.JPG

All comments

guitarhero23

How about something like

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

ELSE `settlementID`
END
)

dojo help 3.JPG

meadow_ryan

thank you

JuanRoaRojas

Hi guys, I have the same issue, I have a column type deciamal with some blanks values, null funtions does not work, when I try to sum the column the final result is blank. 😥

IFNULL(P&L Contribution Margin,0)

NULLIF(P&L Contribution Margin,0)

case
WHEN STRING(P&L Contribution Margin) = '' then 0 else P&L Contribution Margin
end

(CASE
WHEN IS NULL THEN NULLIF(P&L Contribution Margin,0)

ELSE P&L Contribution Margin
END
)
I will appreciate any suggestions