July 24, 2006, 01:44 PM
neuroMAX Function for a ROW of FIELDS
I know there is a MAX function for getting the highest number within one field. What if I have a Report where 1 ROW has 5 COLUMNS/FIELDS of DATA and I want to have a 6th COLUMN/FIELD that displays the MAX VALUE from the 5 COLUMNS/FIELDS?
July 24, 2006, 02:26 PM
ptptry the MAX funtion, a simplified example is below:
----------------------------------------------------------
DEFINE FILE x
COL6/P12.2 = MAX(COL1,COL2,COL3,COL4,COL5,.....);
END
TABLE FILE x
PRINT COL1
COL2
COL3
COL4
COL5
COL6 AS 'MAX VALUE FOR COLS 1-5'
BY SORT1
END
----------------------------------------------------------
Good luck,
Paul.
July 24, 2006, 02:37 PM
neuroAWESOME, that works, thank you thank you!