Sum Of a column from a Data Table without Loop

Help Studio
, ,
6

@madhabhazra0,

Let’s convert it to Double

CDbl(dt.AsEnumerable() _
    .Where(Function(row) Not String.IsNullOrEmpty(row.Field(Of String)("Amount"))) _
    .Sum(Function(row) Convert.ToDecimal(row.Field(Of String)("Amount"))))

The image shows a process in UiPath automating the calculation of the sum of the "Amount" column values from a data table, with non-empty and non-null rows considered. (Captioned by AI)
The image shows a process in UiPath automating the calculation of the sum of the "Amount" column values from a data table, with non-empty and non-null rows considered. (Captioned by AI)705×379 36.9 KB

Output:

image
image501×191 3.38 KB

1 Like