Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculation

Status
Not open for further replies.
mama16

mama16

MIS
Oct 22, 2004
125
US
I'm trying to do this calculation and for some reason it's not working,=Sum([Averagecallpermonth]/[Averagecallpermonth]) in a report

Is that wrong?
 
Sort by date Sort by votes
What are you hoping for with this
=Sum([Averagecallpermonth]/[Averagecallpermonth])
a sum divided by itself??

Hope this helps
Hymn
 
Upvote 0 Downvote
This will always equate to 1
AverageCallPerMonth = 25

= Sum(25/25) = 1
Is this what you want???

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk
 
Upvote 0 Downvote
dah! My fault, I got it! divide that by 24. I think I need a break. hehehe!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
517
dhookom
dhookom
jlr123
  • Locked
  • Question
Access 2010 calculation in table resulting in #NUM!
Replies
4
Views
80
jlr123
jlr123
fsupport1600
  • Locked
  • Question
=SUM Calculation on Report 1
Replies
5
Views
127
dhookom
dhookom
dawnd3
  • Locked
  • Question
Calculation issues Access 2003
Replies
3
Views
71
dawnd3
dawnd3
BrianLe
  • Locked
  • Question
Ending inventory calculation
Replies
3
Views
104
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top