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

  • rebekah
    rebekah Member
    Answer ✓

    Problem Solved

  • nalbright
    nalbright Contributor

    It's good that you were able to find the solution :).

    "When I have money, I buy books. When I have no money, I buy food." - Erasmus of Rotterdam
This discussion has been closed.