Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Morning to all,
Could I please get some help with the following.
I have 4 unique ranking calculation which give me the respective rank based on
only(aggr(nodistinct rank(count(Partno),4,1), Partno))
only(aggr(nodistinct rank(sum(OrderQty),4,1), Partno))
only(aggr(nodistinct rank(sum(TotalSales),4,1), Partno))
only(aggr(nodistinct rank(sum(RProfit),4,1), Partno))
All of which are working perfectly.
What I require is to get an overall ranking based on all of the previous rankings. (Rank Over)
Where currently I can only get the combined sum of the rank.
ie in the Rank Over the results should display :
Your help will be appreciated.
Try this
Rank(Total(-RangeSum(
only(aggr(nodistinct rank(count(Partno),4,1), Partno)),
only(aggr(nodistinct rank(sum(OrderQty),4,1), Partno)),
only(aggr(nodistinct rank(sum(TotalSales),4,1), Partno)),
only(aggr(nodistinct rank(sum(RProfit),4,1), Partno)))),4,1)
Have you already tried this?
Rank(Expression1, Expression2, Expression3, Expression4)
I have thanks, as well as adding the four ranks together and then doing an overall ranking on that result.
Sorry, that is what I meant
Rank(RangeSum(
only(aggr(nodistinct rank(count(Partno),4,1), Partno)),
only(aggr(nodistinct rank(sum(OrderQty),4,1), Partno)),
only(aggr(nodistinct rank(sum(TotalSales),4,1), Partno)),
only(aggr(nodistinct rank(sum(RProfit),4,1), Partno))))
What do you do when you add this as one of your expression
Ok no laughing now,
I modified your suggestion to get the ranking to work. (Rank Over)
Rank(Total(RangeSum(
only(aggr(nodistinct rank(count(Partno),4,1), Partno)),
only(aggr(nodistinct rank(sum(OrderQty),4,1), Partno)),
only(aggr(nodistinct rank(sum(TotalSales),4,1), Partno)),
only(aggr(nodistinct rank(sum(RProfit),4,1), Partno)))),4,1)
And it works perfectly except for one small problem.
It is ranking in the reverse order ????
When I use the example you have posted I get (Sunny)
@
Thanks for the patience
Try this
Rank(Total(-RangeSum(
only(aggr(nodistinct rank(count(Partno),4,1), Partno)),
only(aggr(nodistinct rank(sum(OrderQty),4,1), Partno)),
only(aggr(nodistinct rank(sum(TotalSales),4,1), Partno)),
only(aggr(nodistinct rank(sum(RProfit),4,1), Partno)))),4,1)
Ok no laughing now,
Why not? Laughing is a good thing