DataTable Sum Columns

[yekho (Porori)]

I want to calculate the total horizontally using Linq in the data table.

Ex)
Col1 | Col2 | Sum
100 | 200 | 300

[saijagadesh06 (Jagadeesan)]

@yekho - Hi Welcome to UiPath Forum. I have attached sum link for your reference. Could please refer the link and clarify your doubts. If you not clarify please let me know.

Seperate Sum of Each Row of Two Column

Hello, I have an excel table as below. I have a cycle and in this cycle I get random column from this table. And I want to sum each rows of columns and at the end obtain total number of reference 1, 73 etc. Bu I couldn’t find how to add rows of two columns seperately. [image]

Happy Learning

[vignesh.ks]

Hi @yekho

Please use the below method.

row(“Sum”)=(Convert.ToInt32(if(row(“Col1”).Tostring<>“”,row(“Col1”),0))+Convert.ToInt32(if(row(“Col2”).Tostring<>“”,row(“Col2”),0))

Thanks, Happy Automation

[ppr (Peter Preuss)]

For a row WE can do with following

row.ItemArray.Sum(function (x) Convert.ToInt32(“0” & x.toString))