9 Replies Latest reply: Feb 12, 2017 12:59 PM by Bill Markham RSS

    Percentage flag

    konduri srinivas

      hello guys

      i have data as following

      t1:

      load * Inline[

       

       

      id,count,rate

      1,1,8%

      1,2,17%

      1,3,25%

      2,4,33%

      2,5,42%

      2,6,50%

      3,7,58%

      4,8,67%

      4,9,75%

      4,10,83%

      5,11,92%

      6,12,100%

      ] ;

      and my requirement is  the VALUE which is close to 90% in rate field should get 'high' and others are low.

      for example in the given data for 83% and 92% it should get high remaining should be low

      AND THE RESULT SHOULD BE IN FRONT END(PIVOT TABLE)

       

      NOTE:

      THE VALUES WHICH IS CLOSER TO 90 MEANS ONLY ONE VALUE BELOW 90 AND ONE VALUE ABOVE 90 SHOULD GET 'HIGH'


      EXAMPLE OUTPUT

      count,rate,req

      1,8%,-

      2,17%,-

      3,25%,-

      4,33%,-

      5,42%,-

      6,50%,-

      7,58%,-

      8,67%,-

      9,75%,-

      10,83%,low

      11,92%,high

      12,100%,-

       

       

       

       

       

      ANY HELP IS APPRECIATED,