Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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