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?
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site:
www.stephenkramer.comWould you believe Far Side Lite?
More than 270 original cartoons.