Creating average of row in column

[limfungkeat]

Iterm code	Vendor1	Vendor2	Average
A	10.50	10.20
B	9.33	9.00
C	8.21	7.35
D	5.36	5.05

In straight table , how am i calculating the value for the column "Average" ? - That is average price offered by both of the vendor for that particular item code

[Gysbert_Wassenaar]

RangeAvg(Vendor1, Vendor2)

Or (Vendor1+Vendor2)/2

[limfungkeat]

thanks Gysbert,

The reason why i am not using the scond one (i rather straight forward thought..), is that , what is there is null value in the vendor1/ vendor 2 ?

[limfungkeat]

the RangeAvg() is taking 0 / null value into the calculation, is there any way to exclude null/0 value ? Ie if vendor1 - 10.50 ; vendor2- 0 , then the calculation should divide by 1 not 2 .

[Gysbert_Wassenaar · Accepted solution]

0 is a value, null is not. RangeAvg does not consider null because it's not a value. If you want to disregard 0 then use RangeAvg(If(Vendor1<>0,Vendor1),If(Vender2<>0,Vendor2). And <> 0 means <> exactly 0, not <> 0.00000000000023.

[limfungkeat]

Thanks a lot Gysbert ! Well, i actually convert my source with null value to 0 and it works fine