topic Re: Rank() with greater than set analysis in App Development

Rank() with greater than set analysis

Daniel-Fr — Tue, 26 Mar 2019 15:51:55 GMT

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!

sunny_talwar — Tue, 26 Mar 2019 17:13:07 GMT

Looks okay, but try this (use [ ] instead of ' ')

Sum({$<SalesPerson = {"=Rank(-Sum({$<Sales = {[>0]}>} Sales))<=11"}>} Sales)

Daniel-Fr — Wed, 27 Mar 2019 09:06:24 GMT

Great it works! Thanks a lot!
Does using square braquets mean you want to do a numerical comparison?

sunny_talwar — Wed, 27 Mar 2019 11:16:15 GMT

No, it just means that you cannot use another double quotes, because you have outer double quotes.

Daniel-Fr — Wed, 27 Mar 2019 12:35:37 GMT

Ok thanks for your help!