Forum Discussion

powerrdl's avatar
powerrdl
Helper I
9 years ago
Solved

Bug in COUNT function?

  I am getting same output with COUNT and COUNTA functions for all columns of above data. COUNT(Locn) gives output as 5 even though there are 4 entries and no numeric entry. Not getting error ...
Need Help
Show and Tell
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    Anonymous

     

    COUNTA can count TRUE/FALSE column but COUNT still raises an error.

     

    Best Regards,
    Herbert

Anonymous's avatar
Anonymous
Not applicable
9 years ago

That raises a follow up question, as mentioned in OP.  What will be the functionality difference between COUNT and COUNTA?

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

Anonymous

 

COUNTA can count TRUE/FALSE column but COUNT still raises an error.

 

Best Regards,
Herbert