Collection_Extend_Numeric_Columns
Purpose
Modifies a collection to "fill in the blanks" in columns with numeric names
(See Notes). Returns the modified collection.
Arguments
Collection_Extend_Numeric_Columns( <coll> )
Notes
In rating activities, collections are encountered commonly with column names
that are numeric ranges -- weights or mileages. Suppose we have the following
collection:
Zone
| 000-099
| 100-199
| 200-499
| 500+
|
4
| 36.64
|
| 23.67
| 18.32
|
5
| 59.52
|
| 31.40
| 29.76
|
6
| 69.00
|
| 41.19
| 34.50
|
Columns 2-5 are regarded as having numeric names because the first character
of the name is a digit. The function processes each row from left to right. If a
cell in a numeric-named column has a null value, it is assigned the value of
the cell to its immediate left. In this example, column 100-199 contains nulls for all 3 rows. The function will fill this column with the
values from column 000-099.