Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
Add - before Sum
aggr(rank(-sum({<[RISK STATE]=>}[NET WRITTEN PREMIUM]),4),[RISK STATE]).
Try this:
Add - before Sum
aggr(rank(-sum({<[RISK STATE]=>}[NET WRITTEN PREMIUM]),4),[RISK STATE]).
Great thank you for the help.
You are welcome