9 Replies Latest reply: May 18, 2012 3:09 AM by marcodesa RSS

expression with not null values

marcodesa
Hi all,
I want to calculate the average of the Sales but where the value of the sale is not null!
I try with this expression but nothing 
avg({< [Sales] -= {""} >} Sales)


Someone can help me?

Thanks all.