How to write Greater than symbol in set analysis

[timanshu]

I have a table with bucket field and sales field ->

Bucket    Sales

10-20     100

20-40      30

40-50      50

>50         120

I want to show sale of only >50 in a chart through set analysis. How can I do. Since writing > in set analysis , >50 as whole is not considered as a field value.

Please help.

[sergio0592]

Hi, try with :  =sum({<Bucket={">50"}> }  Sales)

[antoniotiman]

Hi,

Sum({<Field={'>50'}>} Value)         //or {'>=50'}

Regards,

Antonio

[timanshu]

does not work

[timanshu]

does not work

[bharani8]

Try this..

=sum({<Bucket >= {'50'}> }  Sales)

[bharani8]

I think.. what jean-baptiste‌ mentioned will work..

[tresesco]

Is bucket a script generated field? Or, it's a calculated dimension? If calculated dimension, what expression have you used to create that? 

[arvind_patil]

Hi Timanshu,

Try below:

=sum({<Bucket={">50"}> }  Sales)

Thanks,

Arvind Patil

[Peter_Cammaert]

If these don't work, please post an example document for us to check out.

If you want to get rid of this situation quickly, you can always create a parallel field to Bucket that contains unambiguous non-display values, like:

Bucket  Bucket2    Sales

10-20   10TO20     100

20-40   20TO40     30

40-50   40TO50     50

>50     GT50       120

and test for Bucket2 in set analysis like:

=Sum({<Bucket2 = {'GT50'}>} Sales)