Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
May be like this..
=Rangesum(above(total Sum(Sales),0,Period))/
Rangesum(above(total Sum(Quantity),0,Period))
add new Expression: aggr(avg(Sales) / Quantity,Period)
Try this:
RangeSum(Above(Sum(Sales), 0, RowNo()))/RangeSum(Above(Sum(Quantity), 0, RowNo()))
UPDATE: Make sure you set Accumulation back to No Accumulation
May be like this..
=Rangesum(above(total Sum(Sales),0,Period))/
Rangesum(above(total Sum(Quantity),0,Period))