Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hello Kiran,
try with this:
Avg(if(isnum(Quantity),Quantity,0))
Best regards
Hello Kiran,
try with this:
Avg(if(isnum(Quantity),Quantity,0))
Best regards
Try this expression:
=Avg(Aggr(Sum(If(IsNull(Quantity), 0, Quantity)), [Material Code]))
HTH
Best,
Sunny
Hi Kiran,
I think a possible solution could be replace null values with zeros in script.
Best Regards
Pablo