Sum Of a column from a Data Table without Loop

Help Studio
, ,
1

I’m trying to calculate the sum of a particular column ‘Amount’ in a Data Table. The data type of Amount is string. The Sum should be 0, but when I tried using UiPath, it provided me with an incorrect value.
Please find the screenshot below as an example:

image
image283×118 2.01 KB

2

@madhabhazra0,

Use this LINQ in Assign activity.

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

Can you try converting it to integer format .

Please send a screenshot of your activity from Studio

4

This image shows the UiPath Expression Editor with an assignment activity that calculates the sum of a specific column from a data table, excluding null or empty string values. (Captioned by AI)
This image shows the UiPath Expression Editor with an assignment activity that calculates the sum of a specific column from a data table, excluding null or empty string values. (Captioned by AI)1249×442 21.3 KB

SumAMT (variable Type - Double)

5

tried , not working.
if possible, please create the xaml and share
thanks in advance

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
7

image
image897×679 30 KB

A flowchart in a software automation tool illustrates a process that iterates through a data table, summing decimal values from each row and storing the result in a variable named "Sum." (Captioned by AI)
A flowchart in a software automation tool illustrates a process that iterates through a data table, summing decimal values from each row and storing the result in a variable named "Sum." (Captioned by AI)987×466 22 KB

The image shows a list of variables with their names, types, scope, and default values, specifically "DT" of type DataTable and "Sum" of type Decimal, both within the "Main Sequence" scope. (Captioned by AI)
The image shows a list of variables with their names, types, scope, and default values, specifically "DT" of type DataTable and "Sum" of type Decimal, both within the "Main Sequence" scope. (Captioned by AI)967×262 9.28 KB

8

This will definitely work ! Try this @madhabhazra0

Mark it as a solution if it is working

9

yes, it is workinh
thank you @Lalasa_Mulakaluri

1 Like
10

this is also working but within for each row this syntax is not working

11

@madhabhazra0,

LINQ avoids unwanted iterations so this wasn’t for For Each.