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

Gokul001 (Gokul Balaji) January 9, 2023, 6:37am 9

Hi @Kuldeep_Pandey

Check out the XAML file

SumExcelColumn.xaml (16.1 KB)

Try with this Instead of 3 you can use Amount in the expression and check it

Regards
Gokul

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