How calculate sum of total below datatable… Unit TN CN HC CH HO SM CB KM MH Total 1-30 0.067817008 0.062174952 0.780147434 1.4210211 0.06174 0.923536262 2.024384096 0 1.173270112 30-60 0.0084672 0.01292592 0.011495 0.679251706 0.05530112 0.786329264 0.543732924 0.777522864 60-120 0.2…

Hi @domsmgtmeet22 Check this thread,It might helps you [image] How to calculate sum of total in datatable? Studio Hi @saninfo273 (From d In DT.AsEnumerable Let t = {"column1","column2","column3", "column4","column5","column6","column7"}.Sum(Function (x) Convert.ToInt32…

HI, Can you try the following sample? [image] Dim arrCol As String() ={"TN","CN","HC","CH","HO","SM","CB","KM","MH"} dt.AsEnumerable.ToList.ForEach(Sub(r) r("Total")=arrCol.Sum(Function(s) If(Double.TryParse(r(s).ToString,New Double),Double.Parse(r(s).ToString),0)) End Sub ) Sample Sample20240…

Is not working share another code

How to calculate total?

Help Studio

pravallikapaluri (Pravallika Paluri) May 9, 2024, 8:46am 2

Hi @domsmgtmeet22

Check this thread,It might helps you

Hope it helps!!

Topic		Replies	Views
How to calculate sum of total in datatable? Studio studio , question , workflow_diff	10	447	February 29, 2024
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 in datatable? Studio studio , question , workflow_analyzer	3	177	February 27, 2024
Sum of Datatable Studio studio , question , activities_panel	5	1354	August 11, 2023

How to calculate total?

Related topics