Hi. Here are my column formats:
COLUMN AVG(SCORE) HEADING 'AVERAGE SCORE' FORMAT 999.99
COLUMN MAX(SCORE) HEADING 'HIGHEST SCORE' FORMAT 999
COLUMN MIN(SCORE) HEADING 'LOWEST SCORE' FORMAT 999
What I'd like to do is use 999.99 on all three columns but supress the decimals if they happen to be 0. Is there any way to do this?