Hi Andy. Please consider another scenario for calculated properties. This one is more relevant to companies:
My organization's account management lead just yesterday asked for a way to calculate a weighted "priority score" for companies that are already customers. As a rough example: account size property + unresolved support issues property + potential revenue property = priority score.
Tasks related to high-priority records get assigned to specific hubspot owners, low-priority records to different owners. Also a filtered view of companies sorted by this calculated priority score can show at a glance where we need to spend most of our energy.
Would love to see calculated fields built into the CRM, though. It would eliminate our need to need to leverage other tools (like zapier and google sheets) for a handful of our basic CRM usage.
My use case would be to do simple calculations on Amount of sale divided by customer property that is "actual cost of goods" to provide commission statements to sales reps.
Similar to jsola, we'd combine a deal "Amount" field with a custom property dollar amount field. In this case, software licensing fees (in Amount) plus service fees (in a custom property) for total deal revenue.
Currently we need reporting to show just the licensing revenue, so we cannot put the true total in the default deal "Amount."
Second everyhting here. We waste way too much time manually calculating deal fields or 'properties': customer license amount, discount %, net license amount, customer annual maintenance, net annual maintenance, commission %...
All these 'properties' could be auto-calculated from two custom deal fields: # users and % discount.
Great idea, @greg_lewis . We regularly discount on licensing, but never thought to track this in HubSpot. If such a feature were implemented not only would it save our reps time in calculations, but our sales leaders would find the total discounts a great insight at the end of the quarter when viewed per product, per industry, or per sales rep.
In SFDC we have a "weighted amount" field (amount * deal's probability). This is done via a standard formula field type in SFDC. Please add formula as a property/field type.
Unfortunately nothing has been done in nearly a year so I have been forced to move to Salesforce because of this simple missing formula. I hated the idea because Hubspot is amazing in so many ways, but this was a hard requirement from my CEO and my hands were tied.... Big machine, here we come... (p.s. we set up the working calculation in Salesforce in less than 2 hours....)
I'm also looking for this functionality for a client. They had weighted sales figures (deal amount x likelihood percentage). HubSpot, any idea when it will be available?
Hi @jasonzagami. While you are waiting for HubSpot's response you might want to use the revenue projection features built into HubSpot's CRM. Essentially, when you set up your deal stages you can assign a likelihood percentage to close to each deal stage. Each deal is given a dollar amount. Now, when deals progress through the sales funnel your reports can automatically show the projected revenue based on deal amount and likelihood percentage.
Our customer deals are largely based on loan to value, a factor that is calculated on the back end, as homeowners often don't know their loan to value (LTV).
Our previous dev team set up a backend field that did this calculation.
Not being able to have a loan to value field that is autocalculated on the back end for us to see is going to be hugely burdensome. Not being able to group contacts/leads by (LTV) and prioritze, automate replies and workflows is going to be problematic and time consuming.
basic calculations shouldn't be that hard ((property a / property b) * 100) (or not even multipled by 100 would be fine).
... this has been an issue for almost a year and a half. any insight as to when this will be able to launch?