Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions
Users Guide 671
In calculating the sum, null values are ignored.
Examples This expression returns the running total for the values that are not null in the
column named salary:
CumulativeSum(salary)
This expression returns the running total for the values that are not null in the
column named salary in group 1:
CumulativeSum(salary for group 1)
This expression entered in the Value box on the Data property page for a graph
returns the running total for the salary column for the values in the graph that
are not null:
CumulativeSum(salary for graph)
This expression in a crosstab computed field returns the running total for the
salary column for the values in the crosstab that are not null:
CumulativeSum(salary for crosstab)
See also CumulativePercent
CurrentRow
Description Reports the number of the current row (the row with focus).
Syntax CurrentRow ( )
Return value
Long. Returns the number of the row if it succeeds and 0 if no row is current.
What row is current
The current row is not always a row displayed on the screen. For example, if
the cursor is on row 7 column 2 and the user uses the scroll bar to scroll to row
50, the current row remains row 7 unless the user clicks row 50.
Examples This expression in a computed field returns the number of the current row:
CurrentRow()
This expression for a computed control displays an arrow bitmap as an
indicator for the row with focus and displays no bitmap for rows not having
focus. As the user moves from row to row, an arrow marks where the user is:
Bitmap(If(CurrentRow() = GetRow(),"arrow.bmp",""))