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,
Solved! Go to Solution.
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.
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 🙂
It is the 2nd case. Thank you so much! It works for me.