IFNULL - Replace Blank with Text

Reply
Highlighted
White Belt

IFNULL - Replace Blank with Text

I am attempting to use the IFNULL formula to say if the Data Table column "Worksite" is blank, replace the blank with the text "No Worksite Assigned."  I created a valid formula, however, the resulting chart is still blank and does not have the text.

 

IFNULL(`Worksite`,'No Worksite Assigned')

Capture.PNG

 

Any thoughts on a formula to get thisto work? Thanks!

 

 


Accepted Solutions
Major Brown Belt

Re: IFNULL - Replace Blank with Text

OK got it try this one then 

 

case when LENGTH(`Worksite`) = 0 then 'No Worksite Assigned' else `Worksite` end
Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'

All Replies
Major Brown Belt

Re: IFNULL - Replace Blank with Text

Try this 

 

IFNULL(TRIM(`Worksite`),'No Worksite Assigned')

There might be empty spaces that make the field be Not Null

Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'
White Belt

Re: IFNULL - Replace Blank with Text

Good thought! I applied your formula, but no luck. It still appears blank in the table without the text.  I also double-checked my report source and there are no extra spaces. Any other ideas are welcomed, I am willing to try!

 

 

Major Brown Belt

Re: IFNULL - Replace Blank with Text

OK got it try this one then 

 

case when LENGTH(`Worksite`) = 0 then 'No Worksite Assigned' else `Worksite` end
Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'
White Belt

Re: IFNULL - Replace Blank with Text

Yes! The case statement worked. Thanks so much!

 

Capture.PNG

Announcements
Looking for the latest Dojo Community solutions? Click on the "NEW SOLUTIONS' widget title or go to https://dojo.domo.com/solutions Click here!