Total avg in linechart

[francisvandergr]

I like to have an avg of Total(Sales) /  quantity till the periode in my chart

Accumalate is not the solution

I include an example

Has someone a solution ?

[Anonymous]

add new Expression: aggr(avg(Sales) / Quantity,Period)

[sunny_talwar]

Try this:

RangeSum(Above(Sum(Sales), 0, RowNo()))/RangeSum(Above(Sum(Quantity), 0, RowNo()))

UPDATE: Make sure you set Accumulation back to No Accumulation

[settu_periasamy · Accepted solution]

May be like this..

=Rangesum(above(total Sum(Sales),0,Period))/

Rangesum(above(total Sum(Quantity),0,Period))