the difference of offset value 0 and 1

[Mahdoucch03]

the difference of offset value 0 and 1 :

RangeAvg(above(Sum(Sales),0,3))  and RangeAvg(above(Sum(Sales),1,3))

[marcus_sommer · Accepted solution]

The difference is just the starting point - the current row or one above. It's easily to comprehend by putting both expression in parallel within a table-chart - and then maybe playing a bit with the parameter-values.

- Marcus