I have what I thought was a simple formula that worked for over a month. Now when I run the query I’m getting a Division by zero error. The formula is shown below. If anyone can help me create a formula to work around the error or an idea as to how I can, that would great.

GM: ([P_CTRL_RETAIL])-([P_PRICE1])/([P_CTRL_RETAIL])

Thanks you

Corey

is there any chance that the value of the [P_CTRL_RETAIL] field is actually zero? perhaps the field was set to zero accidentally--that would explain why it worked for over a month and suddenly stopped. sorry if this seems like an overly obvious suggestion.

I learned the hard way - from Excel on up - anytime I do division I have to first check to see if the divisor value is either zero or NULL.

It's probably a good idea to use a case statement of an if/then (depending) to test the ([P_CTRL_RETAIL]) value first.