I'm having some trouble conceptualizing a report that I'd like to have: I am wanting to evaluate the accuracy of the Probability % we have assigned to each Stage. For example, let's say that in our org "Qualified" = 10%, "Proposal Submitted" = 40%, and so on. So, do we actually win 10% of OPPS that are qualified? Do we really end up winning 40% of the deals where we submit a formal proposal?
I'm thinking I need to start with an Opportunity History report, but from there I'm getting stuck on what to do next. Thanks in advance!
2 answers
Hi Katie,
The percentages for the Stages on Opportunity are used to calculate the expected revenue, so when you are in the Qualified stage it takes 10% of the Amount and fills out the Expected Revenue, this is then used in Forecasting to calculate the expected profit.
You would begin by creating a power of one field on your opportunities by creating a forumula number field on the opportunity, when you have to add the formula you just put a 1 in the formula section.
Most of the opportunities will go through almost all of the stages you have in your stage picklist, the best way to track the number of deals that go from each stage to lost would be to use the Opportunity history report and then group by To Stage and then the second grouping should be From Stage
You would add the power of one field and click on the arrow next to it and then summarieze this field, you would then filter the report by the To Stage being Closed lost, Closed Won.
You would then need create a formula field on the with a format of percentage and then display the formula on the Grouping 2 stage field then in the formula section you would use this:
Opportunity.Power_1__c:SUM/PARENTGROUPVAL(Opportunity.Power_1__c:SUM, GRAND_SUMMARY)
