NullCount is not getting the correct number of null values

[#1]

I'm working in finding the number of null values and using the NullCount formula. The results that I am getting are different from the number in the excel sheet that consists of the raw data.

The number is excel is 180 while in Qlikview the total amounts to 111.

Other formulas used (get same values as for nullcount) but derived the same results.

  count( IF( IsNull([Security Rating]), [Business Group]))

  count(if(len(trim([Security Rating]))=0,[Business Group]))

Maybe there are other suggestions?

Thank you!

[jvitantonio]

Could you please attach your excel file? It must be something related to format and not getting the right value as null.