Forum Discussion

marcelpinheiro's avatar
marcelpinheiro
Regular Visitor
8 years ago

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

  • 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?

     

  • Hi,

     

    Share the link from where i can download your file.  Also, show the expected result there.