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

Division by Zero

Status
Not open for further replies.

rickm140

Technical User
Jul 29, 2014
5
US
I have a 2-year sales report (YTD and MTD) that I need some help with. It shows the profit % for the grand totals which appear at the top of the report but it will not show the profit % for the detail. Every time I try to create a formula I get "Division by Zero" error message. Can someone help me so that the profit % prints for each column. I have attached a copy of the report for viewing.

Rick Meyer
 
Without seeing the formula that you are using to calculate the percentage I can't be precise but in general terms the approach is to use "If-Then-Else" to test for a denominator of zero. If you require more specific assistance please post the formula you are using.

Cheers
Pete
 
Pete:

thanks for your suggestion. I tried that and it worked flawlessly.

Rick Meyer
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top