I was able to come up with a fix for the Closing Ratio Percentage that HubSpot is lacking. I created a calculated property and called it “Closing Ratio” - it really doesn’t matter what you it call it. We have 2 statuses that are considered awarded. It is very important that all statuses are used below. You have to you HubSpot’s internal value for the property value and not the name that you gave the property. This is the formula that we came up with.
if((([properties.dealstage] == “#########”) or ([properties.dealstage] == “##########”)), 1, 0)
Once this works for you, it’s avalible to use in the reporting tool. I took the averge Closing Ratio on the time frame I wanted, and divided by the total number of sales opportunies.
Hope this helps!