Skip to Content
0
Former Member
Aug 01, 2007 at 11:45 AM

Division by Zero Error

47 Views

Post Author: WebbT

CA Forum: Formula

Using Crystal Professional 10.

Hope you can help. I am trying to calculate a % conversion and the formula below is bringin up the division by zero error. I have looked at a lot of articles on this problem but can't seem to work out how to amend it so that the error doesn't appear. This is obviously stopping users running the report and it is need quite urgently. If someone could explain in simple language it would be much appreciated.

Sum ({ACTIVITY.BUDGET}, {ACTIVITY.USERSTRING1}) / Sum ({@DealCount}, {ACTIVITY.USERSTRING1})