0 Replies Latest reply: Nov 6, 2012 10:13 AM by Dwight Kellett RSS

    Problem with Rank dimension

      Hello:

       

      I'm not sure whats going on as I have the following calculated dimension that works fine:

       

      =aggr(rank((sum({<Scenario = {'Actual'},GRPCOD={140}>}Amount) - sum({<Scenario = {'Actual'},GRPCOD={'150'}>}Amount)) / sum({<Scenario = {'Actual'},GRPCOD={'150'}>}Amount)),Project)

       

      When I try to use a similar calculated dimension on another table which only is slightly different it doesn't work all the time:

       

      aggr(rank((sum({<Scenario = {'Actual'},GRPCOD={140}>}Amount)) - (sum({<Scenario = {'Project Forecast'},GRPCOD={140}, [Fiscal Year], Month, Quarter, [Posting Date] ={"<=$(=Max([Posting Date]))"}>}Amount))) ,Project)

       

      What I mean by that it doesn't work all the time, is that sometimes based on selections made the sorting isn't as expected as the rank isn't always in the order I expected. I speculate the following "filter" may be the problem?

       

      [Posting Date] ={"<=$(=Max([Posting Date]))"}

       

       

      Thanks