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?