Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Someone can help me?
Hello,
Please, look into attached example. It should give you necessary knowledge to sort out your issue.
Kind regards,
Janusz
How about this expression ?
avg({< [Sales] -= {"=Null()"} >} Sales)
Cheers - DV
It doesn't work
I think that avg eliminates nulls automatically, no need to do anything about it. That is, just use
avg(Sales)
No, avg doesn't eliminate null values!
Now I have seen that when the sale value is null it is rappresented in the table as -
I try: avg({<[Sales]-={'-'}>} Sales) but nothing again.
Even, I have assumed that Avg() excludes the Null values. Please can you post the QVW file? It will be easy to see the data. Meanwhile have you tried something like this...
IF(Sales <> Null(), Avg(Sales))
Regards,
DV
Hi,
Avg will always exclude the null and non numeric value. So there is no need to do anything. Use AVG(Sales)
Hello,
Please, look into attached example. It should give you necessary knowledge to sort out your issue.
Kind regards,
Janusz
Janusz - Nice little example! Thanks for sharing.
Cheers - DV
Thanks all!