Calculating SUM of "Debit" Column using Group by "TransactionNo" Column

[ClaytonM]

In your previous image, you have “=>” when declaring ‘x’, which is a C# syntax. You need to use .net syntax which would be .Sum(Function(x)
However, I think you have other issues with your LINQ code.

You can check out this post here about using GroupBy for Sum:

Linq Group By and Sum

Hello, I’m not sure this is the best way, however I got this to work by manipulating the data to a delimitted format using the below steps. Store GroupBy expression to a variable of type IEnumerable< Object > [image] The Output of this returns: [image] Concatenate the header to the items in the list using .Split and .Select You can split by comma, then use Select, and select the item split by “=” [image] Without the headers, we have this: [image] So our new output looks like thi…

Regards.