[DataFormat.Error] We couldn't convert to Number.

[Mohammadwazeri]

Hi Guys,

I am facing an issue in the APPLIED STEPS, when I click on "Filtered Rows" there is no error after the filtered rows I have "Grouped Rows" when I click on the grouped rows then it throws the error "[DataFormat.Error] We couldn't convert to Number."

ANY IDEAS ON HOW TO FIX THIS ISSUE?

Please see the snapshots.

Clicked on the "Filtered Rows"(everything works fine no error).

Clicked on the "Grouped Rows"(throws an error)

Thank you so much in advance!

Mohammad

[HotChilli]

It's difficult to solve because we can't see the line with Grouping.

Try getting the right data types in the columns because most of them are set to 'any' data type and it's not very useful

[Mohammadwazeri]

In the table, I receive this error joined with another table. So I recreated the table again and set appropriate data types but when I get to the point to group rows in the APPLIED STEPS then I receive this error again.

[Mohammadwazeri]

Hi @HotChilli,

Even after I set the appropriate data type still throws the error.