How it works…

There are three arguments defined in the syntax used for the Above() function:

  • Expression = Sum(Sales)
  • Offset = '0'

Since this is zero, the function evaluates the expression on the current row.

  • Count = RowNo(Total)

The third argument tells the Above() function to evaluate the expression over a range of values. In this case, because we are specifying a total inside the Rowno() function, the result would be the number of the row the user is currently on.

The Above() function will return a range of values. Hence, we will use the RangeSum() function to sum up all the values.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset