Subtotal for consecutive rows with conditions

[Antung213]

Hi all,

I am having the issue as follow (please see the attached file, I cannot post the table here for unknown reason).

For the value in column "amount", in case the "interest_payment" is "Yes" and the above cell is also "Yes", it will equal the "accrued interest rate"

Otherwise, it will equal the sum up of rows with "interest_payment" is "No". Is there anyway to make the workflow dynamic since the rows with consecutive "No" can vary?

Thank you so much!

Regards,

[atcodedog05]

Hi @Antung213 

In the below statement

Otherwise, it will equal the sum up of rows with "interest_payment" is "No"

Is it all thats all above or only just above it.

Ex

No 1

Yes 1

Yes 1

No 1

No 1

Yes 1

Is it all above 3 or

just above before the previous yes 2

Can you please confirm.

[atcodedog05 · Accepted solution]

Hi @Antung213 

Here is a workflow for the task. I have built for both the cases.

Output: Calculation value is in output column

Please check and let me know.

Hope this helps 🙂

[Antung213]

It is the 2nd case. Thank you so much! It works for me.

[atcodedog05]

Happy to help 🙂 @Antung213 

Cheers and Happy Analyzing 😀