Hi, after a data scrape into InvoiceAllDT, I want to select only those records where the amount is < 50000 and currency is CAD. Refer the ACME screenshot below.
I am trying the following LINQ and it returns all rows with amount < 50000 but has different currencies including CAD. So the 2nd condition is not working.
(From row In (InvoiceAllDT.DefaultView.ToTable(False,“Invoice Number”,“Vendor Tax ID”,“Invoice Item”,“Total”,“Date”)).AsEnumerable()
Where (CType(Split(Convert.ToString(row(“Total”))," ").ToArray(0),Double) < 50000 AndAlso Convert.ToString(row(“Total”)).Contains(“CAD”))
Any guidance is much appreciated.