How to calulate % of wins by month and year
Hi, I need to create a report with a graph that shows the % of closed/won opportunities based on the month the lead came in. So I need the following columns in a report:
Year/Month | % of Closed/Won Opportunities
e.g. 2012/1 | 10%
2012/2 | 5%
etc
I have a seperate report where the following calculation returns the correct percentage: (Metric Opportunity Wins/ Metric Total # Leads)*100.
However, when I add teh Year/Month column i doesnt work. if i add # of Leads and # of Wins the correct number is shown, but it still wont show the percentage.
What am i doing wrong?
Year/Month | % of Closed/Won Opportunities
e.g. 2012/1 | 10%
2012/2 | 5%
etc
I have a seperate report where the following calculation returns the correct percentage: (Metric Opportunity Wins/ Metric Total # Leads)*100.
However, when I add teh Year/Month column i doesnt work. if i add # of Leads and # of Wins the correct number is shown, but it still wont show the percentage.
What am i doing wrong?
0