2 Replies Latest reply: Jul 29, 2014 1:08 PM by Oscar Marquez RSS

    Take nth row from Aggr?

    Oscar Marquez

      Hi All,

       

      I have this aggr function

       

      aggr(count(XXX)/sum(YYY),Date)

       

      COUNT(XXX)/SUM(YYY) is calculating acheivement percent, what I'm looking for, is to get the date when it reached 98%, firstsortedvalue is not working (at least in the way I'm using it) because it is giving me the top date (equal to 100%). How can I limit the result of aggr only to be those >=98% so I can use firstsortedvalue.

       

      Or if you have any other solution I'd really appreciate it, thanks in advance!