Cannot filter the currency column using Filter coulmn

Help Studio
,
1

Hi,

I am not able to filter the currency column in my datatable.
The filtering condition is to select the values > $1300000000.
Input datatable:
image
I used the below the condition to filter but it doesn’t work:
extractedData=extractedData.Select(“[Worldwide gross]>1300000000”).CopyToDataTable

Could any help me to sort out this?

2

why wont u use filter data table activity?

3

Before you use the query first check the values which are coming in that column… it might be reading it as string and hence this query is not filtering anything… And then you can use filter data table activities to filter…

4

I tried to convert each row to string and then to Double value…still its not working,
Double.Parse(row(“Worldwide gross”).ToString)