I would like to apply a carryover of 12% to one of the column values. I have done this in Excel. I think this can be done by using Retain statement.
But probably I am not writing the codes in the correct way.
A test data with the expected result from excel is attached.
I have already solve this problem. So there is no need to reply to this post
So glad that you were able to solve your problem. If you have time, would you mind posting the answer here? It may help someone else.