Incorrect Result using Avg()

[#1]

Hello All,

I have data with null values in Qty on which I am trying to apply Avg()

Can I achieve it simply by using Avg() only & not by Sum()/Count() method?

Regards

Kiran

P.S. I have attached sample qvw for further information.

[anlonghi2 · Accepted solution]

Hello Kiran,

try with this:

Avg(if(isnum(Quantity),Quantity,0))

Best regards

[sunny_talwar]

Try this expression:

=Avg(Aggr(Sum(If(IsNull(Quantity), 0, Quantity)), [Material Code]))

HTH

Best,

Sunny

[#4]

Hi Kiran,

I think a possible solution could be replace null values with zeros in script.

Best Regards

Pablo