Sum of an specific Column in a Data Row

Help Studio
, ,
1

Hi! I would like to know how to make the sum of an specific column in a Data Table.
The dataTable takes the values from an excel and these are the output columns
image

I want to make the sum of the “Invoice Amount” column.
Also the name of that coumn is variable, so how to make the sum of the column wich name is stored in a variable?

2

give a try on

Assign activity
LHS: SumIA | datatype: double
RHS:

YourDataTableVar.AsEnumerable.Sum(Function (x) CDbl(x(YourColNameOrIndexVar).toString.Trim))
1 Like
3

Thanks it worked!
One thing more, how can I convert the resulted number into only 2 decimals?
The result of the sum is 678544.900000086
how cpuld I end only with 678544.90?

4

A string based option could look like this:
grafik

5

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