Want get the sum of some specific filtered data but unable to do so

Hello everyone

Thanks in advance to all.

I am trying to get the sum of very specific filtered data but not able to do so.

I am trying to get the sum of “Actual balance amt” column for only the last “bill month” column row.

Please check the image for better understanding.

sorry in second point, its current "Ban"

Please check the excel file below::

Dummy sheet.xlsx (14.8 KB)

Hi @AryanSingh - What do you Filter in “Ban” column? Means Criteria to Filter “Ban” column

Regards,
AK

@AnandKumar26

check the excel sheet. It is much bigger with different bans.

What i want to do is filter one ban at a time and retrieve the “Actual balance amt” for last “bill month” value. Check the screen shot

After that i want to add these retrieved values.

Hi @AryanSingh - Please see attached the workflow. If the attached workflow serves your requirement then please mark this as solution to close this query.

Thanks,
AK

ExcelSumActivity.xaml (10.1 KB)

1 Like

ok…let me check.

Thanks

@AnandKumar26

@AnandKumar26

Hey thanx, able to retrieve the value but not able to add them. Please check the screenshot!! The command i used!

I want to get the sum of these values!

Try something like this OutputDT.AsEnumerable.Sum(Function(x) Convert.ToDouble(x(“Actual Balance Amt”).ToString.Trim) ).ToString

Regards,
AK

1 Like

@AnandKumar26

in the assign activity right?? to save it as a variable.

Yes. You are right

@AnandKumar26

Thank you. Problem is resolved.

I have marked it as a solution.

1 Like

Great!!!

Thanks,
AK

1 Like

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