Dear Jeff,

Thanks for the solution, It works except for the small modification at the line 

WHEN Balance < 0 AND NetAmount+Balance>=0 THEN NetAmount+Balance 

Solution will fail when the...

Dear Jeff,

Thanks for the quick response , Can you please give me a solution assuming there is a unique id column for the above sample data.

In real case there will...