How to do sum of specific product values by loop

[Jeeru_venkat_Rao]

Hello friends,

I have a data in excel and want to do sum of BPL product only.
For eg. BPL product total is=23. I want this output.

Thanks in advance.

[supermanPunch (Arpan)]

Hi @Jeeru_venkat_Rao ,

Could you try with the below Expression :

DT.AsEnumerable.Where(Function(x)x("Product").ToString.Equals("BPL")).Sum(Function(x)CDbl(x("Values").ToString))

Here, DT is your Input Datatable which contains the data read using the Read Range Activity.

[Naman_Jain]

@Jeeru_venkat_Rao : Here is the solution

For Assign Activity we use this expression
A=A+Cint(CurrentRow(“Values”))

Regards
Naman

[Jeeru_venkat_Rao]

Thank you @Naman_Jain for quick response.

[Jeeru_venkat_Rao]

Thank you @supermanPunch