Cummulative Balance

[#1]

Hi all

Appreciate your kind effort to advise how to compute the cummulative balance in 3rd table known as Backlog :

The formula for Actual Backlog in Day 6 should be as follows :

= (Actual Order - Actual Sales) in previous periods (ie.days 3...to 5) + (Actual Order - Actual Sales) in current period (ie. day 6).

Thanks & Best Rdgs

Steven

[Miguel_Angel_Baeyens]

Hello Steven

If I got your question right, I'd try something like

RangeSum(Above(Sum(Act_Order) - Sum(Act_Sales), 0, NoOfRows()))

Hope that helps!

[#3]

Hi Miguel A. Baeyens

Thanks for your quick response and kind suggestion, it works well.

Many Thanks & Best Rdgs

Steven

[#4]

Hi Miguel A. Baeyens

Sorry to trouble you again as your recommendation is only correct for all days within same month (Jul) but it did not add up previous month balances (ie. Jun). Please refer to the attached QV for details.

Thank you in advance for your help.

Many Thanks & Best Rdgs

Steven

[Miguel_Angel_Baeyens]

Hello Steven,

Try

RangeSum(Above(TOTAL Sum(Act_Order) - Sum(Act_Sales), 0, NoOfRows()))

To sum all possible values in your column, including previous months.

Regards

[Phan_Anh_Son]

Why is Wrong calculation at Jul 31

Thanks.