When you insert a filter and it pulls fields with nothing in them....

Hey just thought I would post a solution to a problem that I had recently. I was filtering out any sales that had "warranty" in the comments, but it would take out any sales where the comments box was empty. To fix this I entered a beast mode to get rid of the NULL values in my comments column. 

 

CASE WHEN `SO_Comments` IS NULL

THEN ' '

ELSE `SO_Comments`

END

Best Answer

Answers

This discussion has been closed.