Sum the values in the column

datatable
excel

#1

Hi, I am a beginner in uipath. I am trying to add the values of a column and compare it to another variable from webpage. I have read many forums about suming values grouped by column. However, It’s not working for me. Pls do advise on how to do this.
Thank you xoxo


#2

@sangasangasanga if u talking about excel column, use read column activity. Use output of that in for each and inside convert each value to integer and add to temporary variable. u will get required output


#3

@sangasangasanga,Did you check this


#4

Yup and I got it thanks. Basically put this code in assign - dt2.AsEnumerable.Sum(Function(x) Convert.ToDouble(x(“ColumnName”).ToString.Trim) )