Finding the total sum of 2 columns using LINQ

Help Activities
, ,
1

Good Day.

I have this datatable where I have to get the total sum of Time column and Cost column depending on its Project Code. I aim to use LINQ to be more efficient especially when processing thousands of rows.

Kindly see attached files for the desired output and excel file being used. Thank you.

Desired output:
image

ExcelFileSample.xlsx (8.8 KB)

Best regards,
Robert Monsalud

2

try this @Robert_Russell_Monsalud
Main (1).xaml (12.9 KB)

result

image
image488×646 14.1 KB

1 Like
3

Thank you, Sir. I will try your solution

1 Like
4

It worked. Thank you so much, Sir.

5

Hi @Robert_Russell_Monsalud

In this case the group by approach can also be used

image

(
	From row In dt_Data
	Group row By k=row("Project Code").ToString.Trim
	Into grp = Group
	Select dt_Data.LoadDataRow({k, grp.Sum(Function(gr) CInt(gr("Time"))), grp.Sum(Function(gr) CInt(gr("Cost")))}, True)
).CopyToDataTable

XAML for reference

TotalSumOf2Columns.xaml (5.6 KB)

1 Like
6

Thank you, Sir. This is a very great solution too. May I ask what if there will be 2 or more reference columns just like this:

image
image736×591 11.1 KB

and the desired output is something like this:
image

What would be the possible work around?

Kindly see attached file for the excel file being used. Thank you.

ExcelFileSample.xlsx (9.0 KB)

Best regards,
Robert Monsalud

7

Hi @Robert_Russell_Monsalud

It is possible

image

(
	From row In dt_Data
	Group row By
	k1=row("Skill Tribe").ToString.Trim,
	k2 = row("Project Code").ToString.Trim
	Into grp = Group
	Select dt_Data.LoadDataRow({k1, k2, grp.Sum(Function(gr) CInt(gr("Time"))), grp.Sum(Function(gr) CInt(gr("Cost")))}, True)
).CopyToDataTable

TotalSumOf2Columns.xaml (5.7 KB)

2 Likes
8

Thank you so much, Sir. This will be very helpful.

Best regards,
Robert Monsalud

9

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