Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
RangeAvg(Vendor1, Vendor2)
Or (Vendor1+Vendor2)/2
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 ?
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 .
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.
Thanks a lot Gysbert ! Well, i actually convert my source with null value to 0 and it works fine