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]

[image] <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/6/4/5/645770e584fbe5e3a789144965b431436bb61c1d.png" data-download-href="/uploads/short-url/ejF5uiIK3qzIGKCE4x2xDvVAPqR.png?dl=1" title="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)" rel="noopener nofollow ugc">[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 class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/c/e/4/ce47d4771724b98fd055d348e0133ebfd77106ed.png" data-download-href="/uploads/short-url/tqQfJOtVqWYM2H5RflxngksDTqZ.png?dl=1" title="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)" rel="noopener nofollow ugc">[The image shows a list of variables with their names, types, scope, and default…

Sum Of a column from a Data Table without Loop

Help Studio

ashokkarale (Ashok Karale) November 19, 2024, 1:39pm 11

@madhabhazra0,

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

Topic		Replies	Views
Sum of datatable column using C# uipath Studio studio , question , tools	20	3923	April 24, 2022
Sum of a column in data table Studio datatable , studio , question	8	14121	April 20, 2020
Adding Values of column Studio excel , studio , question , activities_panel	6	3588	March 11, 2022
How to calculate a particular datacolumn sum using datatable or structured format? Something Else datatable , activities , studio , string-manipulation , datascraping	17	1203	November 18, 2022
Sum the values in the column Help datatable , excel	5	5535	October 29, 2018

Sum Of a column from a Data Table without Loop

Related topics