How to filter when 2 column cell data is different in data table

Help
1

I have a Excel sheet where I have to use filter to Worldwid gross > 1300000000 and Year >= 2015. I am trying to convert worldwide gross column to int but it is giving error. I have attached my work flow. I have tried with select method as well same result. what am I doing wrong?.
Main.xaml (25.4 KB) project.json (1.1 KB)

2

That value is too large to fit into an Int32 datatype. See the documentation below on the Long datatype (Int64), which will work for your larger value.

3

What he :point_up_2: said :wink:

1 Like
4

Hi, welcome to the community!
Let us know if you solved your issue.