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

powerrdl's avatar
powerrdl
Helper I
9 years ago

Hi Anonymous

 

You are right ! I right clicked in Edit Queries and Transformed as instructed, but it is still not giving 'null' for Product 2 :(

 

Regards

Rameen Dhall

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thats ok! This just means we are making progress.  Doing this normally works in Excel and i expected that to work here, but it looks like it hasn't.  I just tried on my sample set and got the same result.  No matter, lets add another step.  Still in that query editor, highlight the column and right click and select "Replace Values"

 

In the pop up, leave the 'Value to Find' empty and write the word null into 'Replace With'.  It should detect that null is a keyword and then your data should look like my screenshot.