VALUE command
The VALUE command specifies 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.
Syntax
Options
FIRST
Puts the value of the first record found to meet the selection criteria into the cell.
COUNT
Puts a numerical value, equal to the total number of records found that meet the selection criteria, into the cell.
SUM
Puts the total of the values found in all records that satisfy the selection criteria.
CONCAT
Puts the first letter of all unique values found in all records that satisfy the selection criteria, written in a horizontal line in the cell.
Parent topic