I have three (3) Decimal Fields on a single record. I need to add an additional Decimal field that will produce an Average of those values. The problem is I do not know how to account for a record with a missing value. If there are only 2 values present on the record, I need the JavaScript to average the 2 values and ignore the NULL value of the third Decimal field.

This function would then run onChange of those three decimal fields.

Any help would be appreciated!