The VALUE command is used to specify the format of the value that is placed in the cell created by the junction of a column and a row in a matrix report. The VALUE command, and its allowable subcommands are as follows:
The FIRST option for the VALUE command places the value of the first record found to meet the selection criteria into the cell.
COUNT
The COUNT option for the VALUE command places a numerical value, equal to the total number of records found that meet the selection criteria, into the cell.
SUM
The SUM option for the VALUE command places the total of the values found in all records that satisfy the selection criteria.
CONCAT
The CONCAT option for the VALUE command places the first letter of all unique values found in all records that satisfy the selection criteria, written in a horizontal line in the cell.