Help with a Rangesum/before formula

[#1]

I have a range sum formula that works perfectly in a chart that performs a sliding average based on the previous 3 columns in pivot table chart.  The following is the formula

=(rangeavg(before( $(vORDERS,1,3)))  /  (rangeavg(before( $(vINVOICES,1,3)))

The issue I am having is that when i try and use this formula to plot a bar or line chart  I do not get any results.  I would be grateful if anyone could let em  know what I am doing wrong and if thay have any ideas as to a possible workaround.

Many thanks

P.

[lironbaram · Accepted solution]

hi i think

before is only working in pivotchart

you need to replace the before function with above function

[#3]

Liron Baram

Many thanks for the quick response.  Your suggestion works perfectly.

P.

[#4]

Liron Baram

Many thanks for the quick response.  Your suggestion works perfectly.

P.

[#5]

Liron Baram

Many thanks for the quick response.  Your suggestion works perfectly.

P.

[#6]

Many thanks Liron Baram