I need to calculate manager list and resource list colums row coiunt.
check below ss
how can i calculate?
i checked with CurrentRow(“Resource List”).Tostring.Length this formula but giving count for manager as o and resource list as 6 which is wrong.
help me with same.
Can you try with this expression
Int32Variable = Dt.Rows.Cast(Of DataRow)().Count(Function(row) Not row.IsNull("Column name"))
Please try the following expression:
managerCount = yourDataTable.AsEnumerable().Count(Function(row) Not row.IsNull("Manager List"))
Similarly, you get the Resource List count as well.
Hope this helps,
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.