3 Replies Latest reply: Mar 24, 2015 7:19 AM by Manish Kachhia RSS

    Set analysis with expression

      Hi Guys,

       

      I have the following columns in my table:

      Column1          Column2          Column1 - Column2 (this is an expression)

           1                    1                         0%

           4                    2                         50%

           10                  10                       0%

           3                    2                         33%

           5                    2                         60%

       

      Column1 - Column2 will always be positive:

       

      What I need is to return the count of the numbers in Column1-Column2 greater than 0%.

       

      My formula, at the moment, looks like this:

      =Count({< [Column1 - Column2] = {'>0%'} >} [Column1 - Column2])

       

      But this doesn't work.

       

      Any advice is much appreciated!

       

      Thanks