Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Try this
=Count({<country = {"=Sum({<year={[>=2009]}>}sales) > 13000"}>} distinct country)
Sorry it is not 13000 it is 35 in the code part
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)
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.
Try this
=Count({<country = {"=Sum({<year={[>=2009]}>}sales) > 13000"}>} distinct country)
Or this
=Count({<country = {"=Sum({<year={"">=2009""}>}sales) > 13000"}>} distinct country)
Thanks Sunny, The code is working.