8 Replies Latest reply on Apr 10, 2018 6:13 PM by Zhouyi Zhang

    Counting Nulls

    Michael Bernier

      Hi all. I have a challenge I'm hoping you can assist with.   I'm trying to assess Products that are installed on Navy Platforms (Ships). I've attached a sample data set.   Basically I have a calculated field called “Column Label” that will return the year a Product is installed, "GAP" if the product is missing, or  "NA" if the Product isn't applicable to a Site Type.  What I can’t seem to figure out is how I can just count the number of “GAP” per column and not the "NA".    In the attached data set, the column for Product 9 has “NA” ,but it totals the "NA" and the total should be 0.  The calculation field I have called Grand Total counts all the Ships and subtracts the total records per column, but again it doesn't decipher between "GAP" and "NA" and I have no idea how to go about it.