Data table sum into a cell

[jasperlzx (Jasper)]

Hi all,

From my automation, I have many data tables that consists of data for each column.
Can I ask whether is it possible to tabulate the total amount in a single cell?

Thanks in advance!

[sreekanth]

@jasperlzx,Refer this

How to sum all values in a column of an excel/Datatable?

Hi there @Shaista, Certainly, this will allow you to add all data for a specific column for each row. More information can be found here: Thanks, Josh

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

I want to read an excel file which have 2 columns with a few rows (integer values). I need to add a 3rd column in the excel and find the sum of the 1st 2 columns in that 3rd one. need to do this in UIPATH.

How do I group by one column in the datatable and take the sum?

@jamnanin, Refer this, Regards, Dom

[jasperlzx (Jasper)]

Hi, I can’t seem to get this to work and its a little confusing. Any other possible way?

Thanks!

[balupad14 (Balamurugan)]

Hi @jasperlzx,
This will fix your problem.

https://forum.uipath.com/t/datatable-group-by-sum-count-max-min-avg/30778?u=balupad14

Regards
Balamurugan

[Pablo_Sanchez (Pablo Sánchez Hernández)]

Use for each row activity bro ! Then you can do many things to count the amount:

• If you want count the number of cells, save in a variable with an assing activity the count of each row.

• If you want to plus all the values of the whole column, save the value of each row in a variable with an assign activity → var = convert.toInt32(row(“Name of the column”)) (I suposse the value of the row its a integer) ; Plus the values in the same var each row and you will get the sum of all rows in the column.