Dedcut Amount based on the sequence

[SH_94]

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

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

Many thanks

Shanker V

[ShankerV · Accepted solution]

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

[Raj]

Great logic...!