Hi, I am trying to calculate the sum of two variables(of type double) present in column5 . I have taken the sum variable also of DOUBLE data type but i dont know how to write it in excel. Can anybody suggest me please? I am using this function- sum=OutputDT.Compute(“Sum(Gross_Amount)”,“”)

[image] SHAISTA: add the data of 3-4 rows present under the column (GrossAmount) @SHAISTA , I could achieve this with following query, Double d = dt.Select().Sum(Function(x) CDbl(x(“GrossAmount”).ToString)) Regards, Dominic :slight_smile:

Error in storing double value in excel

Help

Dominic (Dominic) February 15, 2018, 6:50am 6

@SHAISTA, Refer this existing solution,

How to sum all values in a column of an excel/Datatable? - #7 by ClaytonM
How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH? - #2 by aksh1yadav
Excel Variable SUM Formula - #7 by aksh1yadav

Regards,
Dominic

Topic		Replies	Views
Summing 4 different collums Help datatable , excel , activities , question	6	812	December 26, 2019
How to sum all values in a column of an excel/Datatable? Help datatable , excel , activities	63	50640	June 24, 2022
How can i sum total in Excel cell for row(not fixed) Robot robot , question	11	3408	November 19, 2021
Sum of the values in the column Automation Ops question , automation_ops	11	577	December 7, 2023
How to sum column up in excel and into a a text box Studio studio , question , activities_panel	5	610	December 6, 2022

Error in storing double value in excel

Related topics