Joining tables and counting new null values

[#1]

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!

[Digvijay_Singh]

Try using the NullCount() function

[swuehl]

Or maybe something like

Count( {1-<[Application Status] = {"*"}>} DISTINCT ITMSNumber)

[#4]

It seemed right but it didn't work. It just counted everything

[#5]

I did this and it returned a count of 1-

=NullCount ( {1-<[Application Status]>}DISTINCT ITMSNumber)

[swuehl · Accepted solution]

What about

Count( {<ITMSNumber = e({<[Application Status] = {"*"}>}) >} DISTINCT ITMSNumber)

[#7]

Thank you so much!

[#8]

Now how do I make an action that selects only those rows?

[swuehl]

Use ITMSNumber as field in your Select in field action and as search string

='=Sum({<ITMSNumber = e({<[Application Status] = {"*"}>}) >} 1)'

[#10]

Worked again. Thank you so much Stefan!