How to compute Sum of a column?

alvin.c.apostol26 · April 13, 2023, 9:46am

Let say I have a column an excel file

with a column below:
Price
100
200
300
400
600

how can I compute it without looping using for each datatable?

Thanks!

Suraj_B_Shetty · April 13, 2023, 9:48am

Try this
Sum=DT.AsEnumerable.Sum(Function(x) Cint(x(“Price”).ToString))

Nitya1 · April 13, 2023, 9:49am

Use this expression.

dt.Compute(“SUM(Price)”, “”)

system · April 16, 2023, 9:49am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.