Hope I am posting to the right place.
In the form there are for separate price fields and a field that automatically fills in an average price for all of them. The problem is not all 4 price fields are going to be filled out in every instance which ruins the average. I need a script the will average the Price fields that have a value.
I was thinking I could create an invisible field that simply state that
I could do that for each of the 4 price fields then in another invisible field count them and use that sum to divide the Total cost to get the average.
Thanks in advance for any help!