Accumulative Sums and Range AVG

[demcug82]

Hi All,

I'm trying to get in a line chart , a moving average of 20 periods of a accumulative sums of amount .
Amount  can be both positive and negative .

I have the dimension "Data" and Measure: "Quantità"

I load data for semplicity with Inline only 4 rows and i tried with a moving average of 3 periods.

I tried for accumulative :   Accumulate Option    and  rangesum     but   no works 

The wrong column it's  "EquityLine" in the 4° row

Any idea?

Demetrio

[Chanty4u]

hi ,

Aggregations and Function Classes

Re: RANGESUM() function ?

[sunny_talwar]

How are you calculating 132.33? Can you elaborate?

[sunny_talwar · Accepted solution]

Try this expression:

=RangeAvg(Above(RangeSum(Above(Sum({<Data=>} [Quantità]), 0, RowNo())), 0, 3))

[demcug82]

Tyvm Sunny!!!

Now Works