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
Titre:
Reporting for duty? Average not a whole number!
Divers
Thread ID:
00174443
Message ID:
00174443
Vues:
57
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform