Don't want to count Null or Blanks

[EricD]

For the below example, I'm trying to get 2 columns (I won't put Defect Code in the dimension, just here for example). MFG_PLT and a count of the "NS" and "NO" fields. I don't want the Null's counted. So, for MFG_PLT # 81, I just want to display the 11 NS. In the case of MFG_PLT # 04 I want to display the sum of the NO and NS entries (12424) but not the 1776 Null Values

I've tried this count({&<DEFECT_CODE={NS,NO}>} DEFECT_CODE) Am I at least in the ball park?

[EricD · Accepted solution]

Forest for the Trees...

Substituted "&" (a typo) with "$" and it worked just fine.