Forum Discussion
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 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?
3 Replies
- marcelpinheiroRegular 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 PAYCan anyone help?
- Ashish_MathurSuper User
Hi,
Share the link from where i can download your file. Also, show the expected result there.
- v-chuncz-msftCommunity Support