Forum Discussion

adriansuteu's avatar
adriansuteu
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Count and Countrows returning the wrong figure

Hi.   I have a table that contains ~2900 rows with columns. You can see it in the screenshot below.   I am trying to count the orders (each order has a row in this table) and create visualization...
Need Help
  • adriansuteu's avatar
    adriansuteu
    9 years ago

    Hi.

     

    I solved the problem.

    I guess it was some kind of bug.

     

    All I did was to copy the source data (the whole table as it is), from a multiple sheet xlsx to a csv file and then use that file as source. And now everything works fine, COUNT, COUNTA and COUNTROWS.

     

    Thanks for your interest!

adriansuteu's avatar
adriansuteu
Icon for Advocate I rankAdvocate I
9 years ago

Hi.

 

I solved the problem.

I guess it was some kind of bug.

 

All I did was to copy the source data (the whole table as it is), from a multiple sheet xlsx to a csv file and then use that file as source. And now everything works fine, COUNT, COUNTA and COUNTROWS.

 

Thanks for your interest!

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Even if I run the same formula by changing the data source to csv... The error remains as it was before...