Count from Datatable with different filters linq

[NHoe (Norman)]

Hi all, I have found a Linq function in the forum that gives me the number of a certain value, that works so far. Now I am faced with the challenge of having to set another filter for the value, as in the example, but this does not work as hoped, who can help me with this?

inputDT.AsEnumerable.Count(Function(r) r(“Date”).ToString=“”) and inputDT.AsEnumerable.Count(Function(r) r(“ANR”).ToString="Test)

[ashwin.ashok ((TheCodingTheory))]

Hi @NHoe ,

Could you try this instead?

inputDT.AsEnumerable.Count(Function(r) r(“Date”).ToString="" and r(“ANR”).ToString="Test")

Kind Regards,
Ashwin A.K

[NHoe (Norman)]

@ashwin.ashok

inputDT.AsEnumerable.Count(Function(r) r(“Date”).ToString="" and r(“ANR”).ToString="Test")

so easy, thank you it works!