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!

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

Dividing 2 Summary Fields in a report (Not working)

Status
Not open for further replies.

scholarthewise23

Technical User
Jun 24, 2003
8
US
Im trying to divide two summary fields in a report. Is this the correct way to do it? =Sum([Field1.[SumOfNumber of Errors])/Sum([Field2].[SumOfNumber of Errors])

Thanks for your help!
 
All you should have to do is place a text box in any group or report footer with a control source of:
=Sum([FieldA])/Sum([FieldB])
I would also check for possible divide by zero:
=IIf( Sum([FieldB])= 0 , 0, Sum([FieldA])/Sum([FieldB]) )
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top