15 Replies Latest reply: Oct 16, 2012 5:06 PM by pkakarla RSS

    Expression not working as expected

      I am having problem with the below expression

       

      =count(if(aggregate<avg({$<MonthEndDate ={$(vMaxSecDate)}>}aggregate),1))

       

      I am using the above expression in a straight table and Sector is my dimension.

       

      Can someone help me what mistake I am doing?

       

       

      Regards