How to perform Addition of all the integers in Cash In, On-Us Check and Not On-Us Check?

[Shahabaz]

Hello Everyone, a little help plz.
I need to add all the integers under three columns and output it on the next right cell (or maybe into a variable) or somewthing.

Is it possible to perform this any easier way, or looping is the only option?
Thanks.

[ppr (Peter Preuss)]

[HowTo] LINQ - First Start # Min | Max | Sum | Average Operator

This HowTo gives an introductory overview of the aggregation Operators: Min, Max, Sum, Average Introduction The aggregation operators are used to retrieve from a collection a particular result by setting the contained items into a relationship. Overview I – Input P – Processing O – Output {2,12,-8,6,14,5} get the lowest value -8 {2,12,-8,6,14,5} get the highest value 14 {2,12,-8,6,14,5} sum up all values 31 {2,12,-8,6,14,5} get the average of all values 5.17 Constraints Perf…

[ppr (Peter Preuss)]

when we can rely on the column values / formats

DataTable.Compute(String, String) Method (System.Data)

with details:

DataColumn.Expression Property (System.Data)

[lrtetala (Lakshman Reddy)]

Hi @Shahabaz

Try this

DataTable.AsEnumerable().Sum(Function(row) row.Field(Of Int32)("Cash In")).ToString

DataTable.AsEnumerable().Sum(Function(row) row.Field(Of Int32)("On-Us Check")).ToString

DataTable.AsEnumerable().Sum(Function(row) row.Field(Of Int32)("Not On-Us Check")).ToString

[Shahabaz]

Hi @lrtetala ,

It does work, but I’m having minor issues regarding the conversion of Double to Int32. I will be digging a bit for the post by @ppr and will update accordingly.

Thanks.
Shahabaz P. L

[lrtetala (Lakshman Reddy)]

@lrtetala

DataTable.AsEnumerable().Sum(Function(row) row.Field(Of Int32)(“Cash In”)).ToString

Can you try to change from Int32 to Double

DataTable.AsEnumerable().Sum(Function(row) row.Field(Of Double)(“Cash In”)).ToString

[Shahabaz]

Hi @lrtetala

It worked. And makes sense too.

Thanking,
Shahabaz P. L

[ppr (Peter Preuss)]

@Shahabaz

issues regarding the conversion of Double to Int32

from the LINQ tutorial, a sample already converting to doubles and handling non parseable values with a default 0