Forum Discussion

adriansuteu's avatar
adriansuteu
Advocate 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!

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi adriansuteu,

 

Can you share the sample file to test? I can't find the columns which you used in the formula.

In addition, can you provide some detail content of your opertions? It will be help for troubleshooting.

 

Regards,
Xiaoxin Sheng

adriansuteu's avatar
adriansuteu
Advocate 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!