Hello,
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.
Gokul001
(Gokul Balaji)
July 4, 2023, 7:50am
2
Hi @Mathkar_kunal
Can you try with this expression
Int32Variable = Dt.Rows.Cast(Of DataRow)().Count(Function(row) Not row.IsNull("Column name"))
Regards
Gokul
Hi @Mathkar_kunal
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,
Best Regards.
1 Like
system
(system)
Closed
July 7, 2023, 7:52am
4
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.