Forum Discussion
marcelpinheiro
8 years agoRegular Visitor
Sum with base value
Hello everyone. I have a bar graphic with 5 days of week. I have 3 columns: Received values, bills to pay and balance. The balance formula is (BASE VALUE+RECEIVED VALUES - BILLS TO PAY) My problem...
marcelpinheiro
8 years agoRegular Visitor
Hello everyone.
I have a bar graphic with 5 days of week. I have 3 columns: Received values, bills to pay and balance.
The balance formula is (BASE VALUE+RECEIVED VALUES - BILLS TO PAY)
My problem is: I need the base value SUM only one time, bring the balance to the next day and then SUM with the received values and subtract BILLS to pay.
Example:
MONDAY:
BALANCE = BASE VALUE+RECEIVED VALUES - BILLS TO PAY
TUESDAY:
BALANCE = BALANCE OF YESTERDAY + RECEIVED VALUES - BILLS TO PAY
Can anyone help?