I have two fields: Listings (currency format) & TotalListings1 (numberformat)
Trying to get a 3rd field (HomeValueAvg - currency format) to calculate:
=Listings/TotalListings1
But nothing appears in the calculated field. I don't do many forms, but I've done some searching & none of the solutions I've found have helped. I had spaced in some of the field names, but removed those.
There's another issue with your formula. When TotalListings1 is empty (or if it equals zero) you will get an invalid operation, as you'll be dividing by zero. If your field's Format is set to Number you will get an error message in such cases. If it's set to None it will show up as Infinity. Either way, not a good outcome.
To prevent this from happening you need to use a script to perform the calculation, like this:
var v1 = Number(this.getField("Listings").valueAsString);
var v2 = Number(this.getField("TotalListings1").valueAsString);
if (v2==0) event.value = "";
else event.value = v1/v2;
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
AdChoices