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

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

powerrdl

 

I’ve got response from the Product Team.

 

This is a recent enhancement to the COUNT function. Previously COUNT function doesn't count strings but just raise an error. We have since enhanced the function to count strings as well. We'll inform the documentation team to update the online document accordingly.

 

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