9 Replies Latest reply: Jan 17, 2017 3:20 PM by Nick Reardon RSS

    Joining tables and counting new null values

    Nick Reardon

      Hi everyone,

       

      I'm joining two tables together by [ITMSNumber]. There's 11,000 [ITMSNumber]. Associated with that [ITMSNumber] there is [Application Status]. There is only 10,000 associations between [Application Status] and [ITMSNumber]. The rest of the 1,000 [ITMSNumber] get Null values for their [Application Status]. How do I count those Null values?

       

      Thanks oodles!