Sum of column where row is of a certain type

[atomic]

The input datable is of type :

I want to store the sum of RA and DA in a two variables.

Can someone help me with a Linq statement that calculates the sum of RA in this case “795,99” and sum of DA in this case “-500,55”.

[q.gio (Gio)]

Hi,

are you sure that the type is List? So do you need a query for all datatables in the list or just for only one?

regards, Gio

[atomic]

Hi,

Its of type list because I use it in a For Each activity.
It’s dynamic and unique for each iteration.

Hope this answers the question.

[NIVED_NAMBIAR (NIVED N)]

Hi @atomic
to calculate the sum of RA use the below linq query

dt1.AsEnumerable().Where(Function(row) row(“Type”).ToString.Equals(“RA”)).Sum(Function(row) Cint(row(“Amount”).ToString))

use the same way for other values too apart from RA

Try this

Regards,

Nived N
Happy Automation

[atomic]

Hi,

Thank you, getting this error:

[NIVED_NAMBIAR (NIVED N)]

Hi @atomic

row(“Type”) should be put

I just edited my response

[atomic]

Getting this error when I run the activity:

[NIVED_NAMBIAR (NIVED N)]

do the excel file contains ‘Type’ column ?

[atomic]

Maybe this helps:

Maybe the problem is that its of type “List”?

[Pradeep_Shiv]

For each argument type should be DataTable type.

[NIVED_NAMBIAR (NIVED N)]

Please check with whether the column is in table or not

or try with row(0) instead of row(“Type”)

[Pradeep_Shiv]

can you try this @atomic,

outDt.AsEnumerable().Where(Function(x) (x(0).ToString.Equals(“RA”))).Sum(Function(r) Cint(r(1))).ToString

Cheers
@atomic

[atomic]

My fault, forgot to change the name of the column.

I changed from Cint → convert.ToDouble but it works perfectly now.

Thanks!

[atomic]

I will try this out also.

Thanks!