I would like to know how to check if math.Round(temData.AsEnumerable(). Average(Function(row) CInt(row (staffName))),1) have no element
i have try using is nothing / (the item above).toString.equals("")
it still not working how should i do to check if it has no element
Could you show the full query?.
the full query is
math.Round(temData.AsEnumerable(). Average(Function(row) CInt(row(staffName))),1).ToString.Equals("")
temData is a table
and staffName is the column name
Think the column eleven has no values to do a average.
temData.AsEnumerable(). Any(Function(row) not row(staffName).tostring.trim.equals(""))
We have to be sure that atleast one cell should not be empty
i think it works thank you so much !
@GUANG_YONG_TEH awesome, please mark my thread as solution so it may usefull to others in the future.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.