In my report I print an Average at the Group Footer level. The average is appearing as 27.666666. My report content is built by a SELECT command with a cursor named RPT as the output of the SELECT statement.

I would like it to read 27 without the decimals.

My Group Footer Report Expression Window shows expression -
INT(CTOD(rpt.EndDate) - CTOD(rpt.StartDate))

I have tried FLOOR(), CEILING(), INT(), etc., but no help.

My Calculate Field Window shows -
Reset: rpt.status
In other words, I calculate the average number of days elapsed whenever the status code changes.
Calculate - Average radio button is clicked on.

I want to report the Average Number of Days Elapsed.

My Detail Report Expression Window shows expression -
CTOD(rpt.EndDate) - CTOD(rpt.StartDate)
The number of days elpased for a certain status code record.

Any idea what's wrong?