Moving Average

[martinr_]

Hi,

I have a line diagram with the dimension year - month.
Formula is ….
Dual(Num(YEAR([DATE]),00)&' - '&MONTHNAME,Num(YEAR([DATE]),00)&NUM(Month([DATE]),00))

If I now show the sum over several years, that fits "normal" buzz correctly.
Formula is ....
Sum(Price)

When calculating the moving average, the display shows no result. Is empty.
Formula is .... Aggr(RangeAVG(Above(Sum({<BELEGTYP={'RE'}>}GESPREISNETTO),0,RowNo())),Num(YEAR([DATE]),00)&' - '&MONTHNAME)

Where is my mistake here? I can not find anything there.

[danilostochi]

Hi, could you post .qvf?

[martinr_]

Hi, here is the qvf file.

[martinr_]

Can someone help me, I have not found a solution yet.