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
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
Retrieving data ...