Rank Function

[Anonymous]

I am using the following function to rank different metrics by state:

aggr(rank(sum({<[RISK STATE]=>}[NET WRITTEN PREMIUM]),4),[RISK STATE]).

My question is how to inverse the order.  I have several ratio metrics where the lowest number would actually be the best versus the normal sales and premiums where the highest number is best.

Thank you for the help,

Justin

[robert_mika · Accepted solution]

Try this:

Add - before Sum

aggr(rank(-sum({<[RISK STATE]=>}[NET WRITTEN PREMIUM]),4),[RISK STATE]).

[Anonymous]

Great thank you for the help.

[robert_mika]

You are welcome