RangeAvg expresison syntax question

[jblomqvist]

Hi all,

I have the following expression:

RangeAvg(Above(Sum(LineSalesAmount),0,RowNo()))

This is used in the following table:

Can anyone please explain to me what the 0 does as the above expression?

The idea of this expression is to show the average of all the rows until the current row. But I do not understand what the zero does

[jonathandienst · Accepted solution]

The second parameter is an offset. 0 means include the current row (offset of 0). 1 would include everything in Above, except the current row.

[jblomqvist]

Hi Jonthan,

Thanks for your reply. I realised it's part of the Above function.

What does the RowNo() function do as part of that? Sorry the expression is not something I am familiar with so trying to understand