Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an expression than gives the sum of the top 10 sales
Sum({$<SalesPerson = {"=Rank(Sum(Sales))<=11"}>} Sales)
I get that if I want the sum of the last 10 I would do
Sum({$<SalesPerson = {"=Rank(-Sum(Sales))<=11"}>} Sales)
Unfortunately I have zero values that I would like to exclude from my calculation, I have
Sum({$<SalesPerson = {"=Rank( - Sum({$<Sales={'>0'}>}Sales))<=11"}>} Sales)
But it doesn't work.
Can anyone tell me what's wrong? Thanks!
Looks okay, but try this (use [ ] instead of ' ')
Sum({$<SalesPerson = {"=Rank(-Sum({$<Sales = {[>0]}>} Sales))<=11"}>} Sales)
Looks okay, but try this (use [ ] instead of ' ')
Sum({$<SalesPerson = {"=Rank(-Sum({$<Sales = {[>0]}>} Sales))<=11"}>} Sales)
Great it works! Thanks a lot!
Does using square braquets mean you want to do a numerical comparison?
No, it just means that you cannot use another double quotes, because you have outer double quotes.