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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formula for SUM

Status
Not open for further replies.
Aug 27, 2003
428
US
Hi ,

I would liek to know what the below formula indicates and when we use it? I am troubleshooting an existing report.

IF SUM({field1,field2}) > 0 THEN

Thanks
 
This will sum the field1 based on field2.

fields2 is a field used to group the values in field1
 
You should show us the entire formula. I'm guessing that this is a check to make sure the denominator in a fraction is not zero, which would otherwise cause a "division by 0" error.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top