I have a database which records weights and I want to calculate the Average on each record. My problem is that sometimes not all the fields will be populated . e.g.
Weight 1 - 35gms
Weight 2 - 45gms
Weight 3 - 40gms
Weight 4 - 0
Weight 5 - 0
Average this would normally divide the sum of the Fields by 5 but as only 3 records have data I need to divide by 3, or by however many have been populated...
Proving a lot harder than anticipated.
Grateful for any help