Help Needed Creating a Points Value against a Number

[#1]

Good Morning,

I am using QlikSense to display my sales teams engagement in using the Salesforce.com application and I have created some metrics that I am observe however I have been asked by the sales leadership to produce a stack ranking of the Account Managers based on a points system...

For example I have a field that measures and visualizes the total number of opportunities that have been created, this is displayed as a percentage against a target goal.

For example if an Account Manager creates 8 opportunities and the goal is 10 then they have 8 points. What I would like to do is create a measure that would only have a maximum of 10 so that someone that creates 20 opportunities does not change the over all results because they are using only one section of the program when in fact they need to be using all 5 area;s of the program.

This is my original formula to figure out the average number of opportunities against the target goal. I just need to learn how to make the result a maximum of 10

Avg([New Opportunitites (Last Month)] / 15)

Thank you all for your help

Barry

[Gysbert_Wassenaar]

rangemin(10,Avg([New Opportunitites (Last Month)] / 15))

[#3]

Gysbert,

Thank you so much this worked perfect.