Specifies a row-number interval or a series of row numbers. You can enter a maximum of 30 characters, both numbers and letters.
Do not fill in this field unless you have selected Row Totaling in the Type field. The program will total the balances for the row numbers entered in the field.
The Row Totaling field is a type of filter field because entering something in the field limits the number of rows that the program includes when calculating the total balance. There are special rules for how they should be entered.
Description | Sample Format | Means |
---|---|---|
Equal to | 7 | Row 7 |
Interval | 11..21 ..25 | Rows between and including 11 and 21 Rows up to and including 25 |
Either/or | 12|13 | Row 12 and 13 |
You can also combine the various format types:
Sample Format | Means |
---|---|
15|20..25 | Row 15 and rows 20 through 25 |
..12|15.. | Rows up to and including 12, and Row 15 and higher - that is, all rows except 13 and 14 |
Important |
---|
Do not include in the definition the row number of the line where the totaling is defined. |
Tip |
---|
For more information about how to work with fields and columns, see Work with Data. For more information about how to find specific pages, see Search. |