Dedcut Amount based on the sequence

Hi community,

I would like to ask how we calculate the " Amout used" as per the following screnshot:

Basically the total of " Amount used" will be equivalent to Final Amount. The concept is we will utilised all the " initital amount" until it's total amount is exactly as per "Final amount"

Thankyou for the help

Sequence Deduction.xlsx

Common Use Cases

Accepted answers

ShankerV

Hi @SH_94

Please find one more simplified way also to achieve the same result.

Workflow:

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

Many thanks

Shanker V

Simplified one Dedcut Amount based on the sequence.yxmd

All comments

ShankerV

Hi @SH_94

Please find the expected output.

Workflow:

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!