Set analysis with expression

[#1]

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

[anbu1984 · Accepted solution]

Are you trying to do count in text box?

=Count(If( [Column1] - [Column2] > 0,1))

[awhitfield]

Hi Adrian,

what is the expression you are using in the third column please?

Andy

[MK_QSL]

=SUM(Aggr(COUNT({<Column1 = {"=Column1 > Column2"}>}1),Column1))