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