6 Replies Latest reply: Aug 9, 2012 10:06 PM by Avula Ganeshkumar RSS

    Set analysis filter

      StatusCall
      S1
      S2
      S3
      N4
      N5

       

       

       

      Here i need to get output as maximum value with status as 'S'.  so i am using set analysis... with

       

      =only({<call={"$(=max(call))"}>}call).... i will get maximum value as 5...  as out put..

       

      StatusCall
      S-
      S-
      S-
      N-
      N5

       

      Now i tried =only({<Call={"$(=max(Call))"},Status={"S"}>}Call)....and   =only({<Status={"S"},Call={"$(=max(Call))"} >}Call)....but the my put is like below...

      i didn't get any value..

       

      StatusCall
      S-
      S-
      S-
      N-
      N-

       

       

      and one more issue i am facing, tried to supress the Null values...then the out put must be

       

      StatusCall
      S3

       

      but it fails,,, i supressed every thing i need to do.. please telle me solution for the above suitation..

       

      Thanks in advance...,

      Ganesh.Avula.