Forum Discussion

Mohammadwazeri's avatar
Mohammadwazeri
Helper III
3 years ago

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

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

Need Help

3 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    3 years ago

    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's avatar
      Mohammadwazeri
      Helper III
      3 years ago

      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.