Calculating a new value based on the value of a prior row
Hello,
I have a table set up similar to the on below:
Date| Starting Balance | Quantity Received | Quantity Used | New Balance
The new balance is the starting balance for the next row.
So for Row 1... The formula is
Starting Balance + Quantity Received - Quantity Used = New Balance
For Row 2 to End for each part it is
Previous Lines New Balance + Quantity Received - Quantity Used = New Balance
I think you can do this by adding a rank row and some Case Statements but I am getting my self wrapped around the Axle.
Any help will be appreciated.
Mike
I have a table set up similar to the on below:
Date| Starting Balance | Quantity Received | Quantity Used | New Balance
The new balance is the starting balance for the next row.
So for Row 1... The formula is
Starting Balance + Quantity Received - Quantity Used = New Balance
For Row 2 to End for each part it is
Previous Lines New Balance + Quantity Received - Quantity Used = New Balance
I think you can do this by adding a rank row and some Case Statements but I am getting my self wrapped around the Axle.
Any help will be appreciated.
Mike
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Good to know that my post helped in resolving your issue! Request you to please close this question in case there are no follow-up queries.
ASKER
I assigned you as the best solution. Is there anything else I have to do to close it?
Hello!
You may need to click on "Next" and then close the question (http://support.experts-exchange.com/customer/en/portal/articles/2527982-how-do-i-close-my-question-).
Thanks! :)
You may need to click on "Next" and then close the question (http://support.experts-exchange.com/customer/en/portal/articles/2527982-how-do-i-close-my-question-).
Thanks! :)
ASKER