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

rebekah

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

rebekah

Problem Solved

rebekah

Problem Solved

nalbright

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