decimal columns: avareage function and blank entries

[luisandres]

Hello, I am stuck, I have four columns of type decimal:

weighing 1 (ex. 1.1234 grams)
weigh-in 2
weigh-in 3
average weight

the average weight column has to average the three weigh-ins columns, but sometimes only 1 or 2 weigh-ins are entered.
the decimal form automatically enters a zero for me, giving me an erroneous average. How can i fix this?

[luisandres]

I tried to use decimal("") in initial value, but it doesn't work.
neither is this in the average column:
average(list(
IF([1st Weighing]<>0,[1st Weighing],decimal("")),
IF([2nd Weighing]<>0,[2nd Weighing],decimal("")),
IF([3rd Weighing]<>0,[3rd Weighing],decimal(""))
))

[TeeSee1 · Accepted solution]

As a workaround, try..

([wt1]+[wt2]+[wt3])
/
(IF(ISBLANK([wt1]),0,1) + IF(ISBLANK([wt2]),0,1) + IF(ISBLANK([wt3]),0,1))

[luisandres]

thanks, that works!

[Marc_Dillon]

---

@TeeSee1 wrote:

(IF(ISBLANK([wt1],0,1) + IF(ISBLANK([wt2],0,1) + IF(ISBLANK([wt3],0,1))

---

Or:

COUNT( LIST( [1],[2],[3] ) - LIST(0,"") )