HI Team, i want to do sum of my D column so how i can do [image]

HI @Kuldeep_Pandey Use Assign activity and create the Variable as System.Double Use this expression in the RHS in Assign activity (From d in dtData.AsEnumerable Where Not (isNothing(d(3)) OrElse String.IsNullorEmpty(d(3).toString.Trim)) Select v = CDbl(d(3).toString.Trim)).Sum(Function (x) x) Re…

Excel key

Help Robot

Anil_G (Anil Gorthi) January 9, 2023, 5:48am 4

@Kuldeep_Pandey

Another method

dt.AsEnumerable.Sum(function(x) if(IsNumeric(x("Amount").ToString),CDBL(x("Amount").ToString),0)).ToString

dt.Compute("Sum(Amount)", string.Empty).ToString

cheers

Topic		Replies	Views
How to sum column up in excel and into a a text box Studio studio , question , activities_panel	5	612	December 6, 2022
Calculate sum of excel column Help excel , activities	25	9303	October 25, 2019
Linq query for excel automation Help datatable , excel , activities , question	12	3568	November 11, 2019
How to calculate the total sum Something Else	4	762	October 4, 2022
SUM VALUE OF COLUMN Activities excel , activities , question	12	1878	October 10, 2021

Excel key

Related topics