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
Miscellaneous
Thread ID:
00174443
Message ID:
00174500
Views:
22
Steve,

You'll have to use the int(), floor(), ceiling() or round() function to get the value you want.

>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.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform