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.