3 Replies Latest reply: Dec 20, 2012 3:14 AM by Manish Kukreti RSS

    Problem in Cal. Dimension

      Hi Guys

       

      Why my following expression is not working ????

       

      =ValueList($(If(aggr(Rank(Sum(Sales)),Product) <= 5,Product)))

       

      If i am removing the $ sign still i am getting error. and if i am putting ' '  then no error but QV is not evaluating the condition(If(aggr(Rank(Sum(Sales)),Product) <= 5,Product)) rather considering it as a text.

       

      Please Help