topic Re: Rank Issue in App Development

Rank Issue

cmorri1988 — Tue, 19 Sep 2017 15:49:09 GMT

Hi,

I am having issues ranking the below, with the attached table image and application for the BINDING DIFFERENCE measure.....

Applying rank() ranks the resulting number as 1 for all results within the table.

Only({1<ID = p({<Genre = (p(Genre)), [Sub Genre] = (p([Sub Genre])),

Literal3 = (p(Literal3)),

[Price] = {">=$(vMinCTPrice)<=$(vMaxCTPrice)"},

[Pub Date Num] = {">=$(vMinCTPubDate)<=$(vMaxCTPubDate)"},

ID = e(ID),Author = , Title =, ISBN =>})>}-Binding_Prioritisation

Sum({$<Genre = (p(Genre)) , [Sub Genre] = (p([Sub Genre])), Literal3 = (p(Literal3))>}TOTAL Binding_Prioritisation))

Any help would be greatly appreciated.

Thank you!

sunny_talwar — Tue, 19 Sep 2017 15:53:47 GMT

Have you tried different mode and fmt for Rank?

sunny_talwar — Tue, 19 Sep 2017 15:59:41 GMT

May be this

Num(Rank(TOTAL Only({1<ID = p({<Genre = (p(Genre)), [Sub Genre] = (p([Sub Genre])),

Literal3 = (p(Literal3)),

[Price] = {">=$(vMinCTPrice)<=$(vMaxCTPrice)"},

[Pub Date Num] = {">=$(vMinCTPubDate)<=$(vMaxCTPubDate)"},

ID = e(ID),Author = , Title =, ISBN =>})>}-Binding_Prioritisation

Sum({$<Genre = (p(Genre)) , [Sub Genre] = (p([Sub Genre])), Literal3 = (p(Literal3))>}TOTAL Binding_Prioritisation)), 4))

cmorri1988 — Tue, 19 Sep 2017 16:10:31 GMT

Thanks!

Seems to rank by smallest SELECTED ISBN BINDING so far, and not the difference.

Thanks again

cmorri1988 — Tue, 19 Sep 2017 19:31:51 GMT

Does anyone have any ideas on how to rank the oiginal expression?

Thanks in Advance

cmorri1988 — Wed, 20 Sep 2017 10:57:26 GMT

Hi Sunny, I just had to make the difference a positive, and your ranking suggestion worked, thanks again!!

=Num(Rank(TOTAL (fabs(Only({1<ID = p({<Genre = (p(Genre)), [Sub Genre] = (p([Sub Genre])),

Literal3 = (p(Literal3)),

[Price] = {">=$(vMinCTPrice)<=$(vMaxCTPrice)"},

[Pub Date Num] = {">=$(vMinCTPubDate)<=$(vMaxCTPubDate)"},

ID = e(ID),Author = , Title =, ISBN =>})>}-Binding_Prioritisation

Sum({$<Genre = (p(Genre)) , [Sub Genre] = (p([Sub Genre])), Literal3 = (p(Literal3))>}TOTAL Binding_Prioritisation)))), 4))

sunny_talwar — Wed, 20 Sep 2017 11:14:00 GMT

That is super