Need to sum 30000(Rows) Data using Excel. Currently i am using the query[(Variable).AsEnumerable.Sum(Function(x)Double.Parse(x(“Amount”).ToString))]. It has taken 15 Mins. Kindly suggest is there any other way to sum the data within a short time.
Hello @prasanna_Y
If youa re trying to find the sum of a single columns you can use a Write cell activity and in teh value use the formula. You can refer below.
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu