I have an expression in where I subtract dates to find out how long something took as in -
CTOD(mytable.startdate) - CTOD(mytable.enddate)
That works fine.
But later I take that column of numbers and in a Grouping I do
the same expression as above, but I also add the Calculation to the expression. I choose Average radio button and the mytable.fieldname that I am doing the grouping break on. In other words, I want an average of those days that I computed prior to the Grouping report line.
THE ONLY PROBLEM IS THAT MY AVERAGE is NOT a WHOLE NUMBER!
How can I pick Average Radio Button and force the number to a whole number without decimal places and a decimal after it.
Help please and thank you.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site:
www.stephenkramer.comWould you believe Far Side Lite?
More than 270 original cartoons.