Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Forest for the Trees...
Substituted "&" (a typo) with "$" and it worked just fine.
Forest for the Trees...
Substituted "&" (a typo) with "$" and it worked just fine.