Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reporting for duty? Average not a whole number!
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Reporting for duty? Average not a whole number!
Miscellaneous
Thread ID:
00174443
Message ID:
00174443
Views:
56
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.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Next
Reply
Map
View

Click here to load this message in the networking platform