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

[AryanSingh]

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)

[AnandKumar26 (Anand Kumar)]

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

Regards,
AK

[AryanSingh]

@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.

[AnandKumar26 (Anand Kumar)]

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)

[AryanSingh]

ok…let me check.

Thanks

@AnandKumar26

[AryanSingh]

@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!

[AnandKumar26 (Anand Kumar)]

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

Regards,
AK

[AryanSingh]

@AnandKumar26

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

[AnandKumar26 (Anand Kumar)]

Yes. You are right

[AryanSingh]

@AnandKumar26

Thank you. Problem is resolved.

I have marked it as a solution.

[AnandKumar26 (Anand Kumar)]

Great!!!

Thanks,
AK