Set Analysis

[nkumarkanduri]

Hi I am trying to find the  count of unique number of countries which have the sum of sales from year 2009 greater than 35000. But I ended getting 0 as my result. But there countries with sum of sales from 2009 greater than 35000. Please find the code:

=count({(<country={"=SUM({<year={'>=2009'}>}sales)>13000"}>)} distinct country)

[nkumarkanduri]

Sorry it is not 13000 it is 35 in the code part

[Vegar]

It could be syntax related,  I made some minor changes to the parentheses in your expression

=count({<

country={"=SUM({<year={'>=2009'}>}sales)>13000"}

>} distinct country)

[nkumarkanduri]

The code is working if we select only one year but when we are using ">=2009" in place of just "2009" it is not working.

[sunny_talwar · Accepted solution]

Try this

=Count({<country = {"=Sum({<year={[>=2009]}>}sales) > 13000"}>} distinct country)

[sunny_talwar]

Or this

=Count({<country = {"=Sum({<year={"">=2009""}>}sales) > 13000"}>} distinct country)

[nkumarkanduri]

Thanks Sunny, The code is working.