Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reporting for duty? Average not a whole number!
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00174443
Message ID:
00174500
Vues:
23
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform