Sum of column groupped by identifier

[abdel (Robot usa)]

Hello,

I had to do the sum of columns related to their identifier:

FR550	COMMON	ENT2622837		31/03/2018	25200000
FR550					25200210
FR550		ENT2622837			25200230
FR550		ENT2622837			45200100
FR550		ENT2622837			45200000
FR550		ENT2622837			61540900
FR7K0		ENT2612259			45200000
FR7K0		ENT2612259			45200100
FRY90	COMMON	0012611448			25200130
FRY90	COMMON	0012611448			61540900
FRY90	COMMON	0012611448			45200100

keep only in a datatable: FR550 sum of th 4th column
FRY90 sum of th 4th column

[AshwinS2 (Ashwin S)]

hi @abdel

Check this

dt.Compute(“Sum(“FR550”)”, “”).ToString();

Thanks
Ashwin S

[Prakshi_Tyagi]

You can do it using group by in LINQ. Let me know if you need an example.

[Madhavi_Jaiswal]

Compute Sum method requires ColumnName as parameter. You have given the value as parameter.

It should be something like this:
Convert.ToInt32(dt.Compute(“SUM(Column2)”, “Column1 =‘FR550’”))

Main.xaml (7.5 KB)

[balupad14 (Balamurugan (BalaReva))]

Hi @abdel,

You can use the groupbyAggregation Activity in the below package.

BalaReva.DataTable.Activities

Hi Friends. Below you have Documentation and Sample attachment for the “BalaReva.Datatable.Activities” You can find the Activities in DataTableExtensions NameSpace [image] Add Data Row Range It allows to add collection of datarow into DataTable. Sample File : AddDataRowRange.zip (7.8 KB) Remove Data Row Select It allows to remove the data rows based on the Select(Where) condition from DataTable. Sample File : RemoveDataRowSelect.zip (7.6 KB) Group By Aggregation(Sum,Count,Avg,Max,…

BalaReva.DataTable.Activities

Here you can see the quick reference by the picture [image] Regards Balamurugan

Regards
Balamurugan

[balupad14 (Balamurugan (BalaReva))]

Hi @abdel

Here I have attached the sample for your situation which is from " BalaReva.DataTable.Activities".

File : SumAbdul.zip
(13.7 KB)

This is the output.

You have to install the package like below.

[Odunayo_Ogundepo]

You can sum up the columns based on a condition using a LINQ query.
see code below;

 **var sumOfA = dt.AsEnumerable()**

** .Where(dr => dr.Field(“ConditionalColumn”).Equals(“A”))**
** .Sum(dr => dr.Field(“Column to sum”));**

You can also use a datatable compute function

See code below;
var sumOfA = dt.Compute(“Sum(Column to sum)”, “[Conditional Column] = ‘A’”);

Reference:

Get SUM of DataTable column