Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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))
Thanks!
Seems to rank by smallest SELECTED ISBN BINDING so far, and not the difference.
Thanks again
Does anyone have any ideas on how to rank the oiginal expression?
Thanks in Advance
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))
That is super