This happens when you try to divide by zero, which is illegal. You need to
use a script that checks if the divisor is zero, and only if it's not
proceeds with the calculation.
How are you calculating this "average" field?
What is the code you entered into the calculation method?
What is the name of the field for the "Homes sold in the past 90 days"?
Since you have a constant there should not be a problem.
With a field name of "HomeSales" for the number of homes sold in the past 90 days you can use the Simplified Field Notation:
HomeSales / 3
If the field name has spaces then you need to use the "\" before the space. So if the field name is "Home Sales":
Home\ Sales / 3
The Field name that I enter the number of sales is "90Days" No spaces.
The calculations I've tried are:
90Days / 3
I don't know if the spaces matter?
Field names for simplified field notation should not start with a number.
I would have never thought of that! When I get back to my Mac I'll change it and see if that works! Thanks!
OK, I renamed the field "ninetydays" and that worked dandy for that simple calculation. Thank you so much!