7 Replies Latest reply: Jun 7, 2011 9:23 AM by Ganesh T RSS

    variable in Set analysis

      ID     Limit_1     Limit_2

      -------------------------------------
      a     100           100
      b      200           200
      c      300           100
      d      400           200

       

       

      Using the above data, I ve created a variable in the front end as follows , diff=Limit_1-Limit_2


      Here  i want to count IDs having the diff>0 using set analysis using the below expression.


      =count( {$<'$(diff)' = {“>0”}>} ID )

       

      But the above one is not working .Can anyone correct it.