need to calculate sum of total all columns…entire datatable. for example datatable, Date column1 column2 column3 column4 column5 column6 column7 Total 1-3 17 10 15 4 47 15 56 3-7 9 4 3 14 4 1 Total 26 14 18 4 61 19 57

Hi @saninfo273 Please check this [image] How to calculate totel in datatable? Studio Hi @saninfo273 Please check this [image] (From d In DT.AsEnumerable Let t = {"KTN","KCN","KHC", "KCH","KHO","KSM","KTV"}.Sum(Function (x) Convert.ToInt32("0" & d(x).toString.Trim)…

Hi @saninfo273 (From d In DT.AsEnumerable Let t = {"column1","column2","column3", "column4","column5","column6","column7"}.Sum(Function (x) Convert.ToInt32("0" & d(x).toString.Trim)) Let ra = d.ItemArray.Take(d.ItemArray.Length - 1).Concat({t}).ToArray Select DT.Clone.Rows.Add(ra)).CopyToDataTab…

@saninfo273 , Try this one. [image] How to calculate totel in datatable? Studio Use datatable expression property. e.g: Use assign activity. dt.Columns("Total").Expression = ("[KCH]+[KCN]+[KHC]+[KHO]+[KSM]+[KTN]+[KTV]") Thanks, Ashok slight_smile Thanks, Ashok …

upload assign activity image…

@saninfo273 If you find solution,Please do mark it as solution to close the loop and it will help others too.if you have any queries, can ask . Regards

How to calculate totel in datatable? (“[KCH]+[KCN]+[KHC]+[KHO]+[KSM]+[KTN]+[KTV]”) Here you go. [image] [image] It’s easiest and simplest way. Thanks, Ashok :slight_smile:

the output is incorrect… Date KTN KCN KHC KCH KHO KSM KTV Total 03-Jan 17 10 15 4 47 15 56 4.10155E+12 07-Mar 9 4 3 14 4 1 Total 26 14 18 4 61 19 57 4.14186E+12

@saninfo273 Please try this [image] How to calculate sum of total in datatable? Studio Hi @saninfo273 Please check this https://forum.uipath.com/t/how-to-calculate-totel-in-datatable/723008/2?u=lrtetala [image] (From d In DT.AsEnumerable Let t = {"Column1","Column2"…

It might be due to DataTable column data types. If it’s non numeric it will not work.

How to calculate sum of total in datatable?

Help Studio

ashokkarale (Ashok Karale) February 29, 2024, 7:06am 4

@saninfo273 ,

Try this one.

Thanks,
Ashok

Topic		Replies	Views
How to calculate totel in datatable? Studio studio , question , activities_panel	4	246	February 28, 2024
How to calculate total in entire datatable? Studio studio , question , activities_panel	9	253	February 28, 2024
How to calculate total? Studio studio , question , workflow_diff	4	150	May 9, 2024
How to calculate total in datatable? Studio studio , question , workflow_analyzer	3	177	February 27, 2024
Sum of Datatable Studio studio , question , activities_panel	5	1356	August 11, 2023

How to calculate sum of total in datatable?

Related topics