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:36am 2

@SHAISTA, this will help you,

Regards,
Dominic

Topic		Replies	Views
How to sum all values in a column of an excel/Datatable? Help datatable , excel , activities	63	50327	June 24, 2022
How can i sum total in Excel cell for row(not fixed) Robot robot , question	11	3380	November 19, 2021
Sum of the values in the column Automation Ops question , automation_ops	11	503	December 7, 2023
How to sum column up in excel and into a a text box Studio studio , question , activities_panel	5	607	December 6, 2022
Excel Variable SUM Formula Help	20	10987	February 15, 2018

Most Active Users - Yesterday
Yoichi
ashokkarale
jast1631
Anil_G
adiijaiin
Eric_Alvarado
mukeshkala
Daniel_Rabin1
Avala_Parameswara_Reddy
natcmll
More details...

Error in storing double value in excel

Related topics