WORKAROUND
To work around this behavior, use the appropriate method for your situation.
Method 1: Values Are Greater Than the Maximum Value Allowed
If you use a formula and the #ERROR value is displayed because values are greater than the maximum value allowed in a field, divide the result of the formula to reduce the values of the numbers below the limit.
For example, if you have a formula in the
Duration1 field that equals the
Duration field multiplied by 35,000, the
Duration field equals #ERROR if the value in the
Duration1 field is greater than 72,270 days. You can divide the value by a factor, such as 100, to maintain values that are below the maximum of 72,270. You would need to note that the values in this field are 100 times greater than what is displayed. The following is an example of this:
Method 2: Division by Zero
If you use a formula and the #ERROR value is displayed because a function is dividing a value by zero, use the IIF function to display a value that you choose instead of the #ERROR value.
For example, if you have a custom function in the
Number1 field that divides cost by actual cost, you receive the #ERROR value when the
Actual Cost field equals zero. You can use an IIF function to display zero when the
Actual Cost field equals zero, and display the value of cost divided by actual cost when the
Actual Cost field is not zero. The following is an example of this:
IIf([Actual Cost]=0,0,[Fixed Cost]\[Actual Cost])