The most important tip is to add a IF statement to any formula where a divide by zero (0) could occur.
"#Error!" displays for a formula field whenever an error occurs while calculating the value of a formula. To resolve the error, check your formula:
- Is the formula dividing by zero? If so, check if the denominator of your expression is zero and provide an alternative value. For example, the following campaign formula field is blank if the number of opportunities is zero:
IF( Quantity > 0, Quantity/ Quantity, null)
- Is the formula calculating the square root of a negative number? If so, use an IF function similar to the one above to check if the value is a positive number.
- Is the formula calculating the LOG of a negative number? If so, use an IF function similar to the one above to make sure that the number is positive.
- Is the formula using the VALUE function with text that contains special characters?
- Is the formula disabled or referencing a disabled formula field? XpandedReports tries to prevent formula fields when they are deleted and they deleted. When deleting formulas, make sure that dependent formulas are deleted first.
| |
|
