BAQ Filtering out blank fields from calculated field

Hi All,

So I was going to post something about needing help with my BAQ but as I was typing it out I realised the problem, so thanks!