Calculate Margin %

[Edyta7510]

Hi All, 

I need to be able to visualize Margin% = Total contract value margin/ Total contract value 

HubSpot doesn't have this native property, from what I see it's impossible to create calculated product properties, and at a deal level I cannot use product property in this calculation. 

Any way to solve this? 

Many thanks!

[HFisher7]

@Edyta7510 - It is possible to access line item propertiesand create formula fields within Datasets.

This would enable you to show the 'Total contract value margin / Total contract value' figure in a report

[kvlschaefer]

Hi @HFisher7,

Thanks for your contribution! 

Cheers,

Kristen 

[McGhee]

We also need this as well as the ability to create a workflow so we can alert RevOps if the Margin % for a deal falls below a certain number. 

[McGhee]

If HubSpot could create TCV margin as an auto calculated deal property from Line Items, like TCV already is, this would make this easy for us to do.

[McGhee]

Here's what I did:

1. Created a Products property called Product Group and grouped like Line Items/Products
2. Created Deals proprerties Called (Group) TCV for each group
   1. Field type: Rollup
   2. Calculated property type: Sum
   3. Associated record type: Line Item
   4. Associated record property: Total contract value
   5. Condition: Product Group = (Group)
3. Created a second Deals property called (Group) TCV Margin where the Associated record proprerty is Total contract value margin instead of Total contract value
4. Created a third Deals proprerty called (Group) TCV Margin %
   1. Field type: Equation
   2. Calculated property type: Custom equation
   3. Equation: ((Group TCV Margin / Group TCV) * 100)
5. Created a Workflow that sends an internal email to Operations if (Group) TCV Margin % falls below a certain number

[JDeSousaRocha]

Hi @McGhee,

I am trying to replicate this but I cant find any of this terminology when creating the property.

Could you help?

[McGhee]

Field type might be listed as calculation, not rollup. Then use sum for the calculation type and then select line itms and then TCV/TCV margin when building your deal properties.

[DianaGomez]

Hi @McGhee., i hope you are doing well!

Thanks for sharing!

Best,

Diana

[Edyta7510]

@McGhee of course! this would be really great. today by using my workaround with Zapier, I am limiting my team to apply the following rule: one deal = line item. which is not ideal... 

[esealpha]

The Zapier connection is good to know. It's quite annoying that HubSpot gives you the ability to calculate a field....but only on their terms.

[Edyta7510]

Hi @himanshurauthan I found a workaround to execute what I wanted using zapier. 

All calculations are done at the deal level. 

[MPastranaRios]

@Edyta7510  how do you set this work around?

Do we know why hubspot won't add the calculation function to products? 

And if they already calculate margin from the product line items in quotes, why they can't create a margin % as well? 

[himanshurauthan]

That's great thank you for sharing! 🙂

[kvlschaefer]

Thanks for sharing this update with us, @Edyta7510!

[TiphaineCuisset]

Hi @Edyta7510 

Thank you for reaching out.

I want to tag some of our experts here - @himanshurauthan @LaurenRyan @HubDoPete do you have any advice for @Edyta7510 on this?

Thank you!

Best

Tiphaine

[himanshurauthan · Accepted solution]

Hello @Edyta7510,

I am afraid to say that currently, there is no straightforward workaround to do this. The reason is calculation property is not currently available for the product.

Regards,

[Edyta7510]

Hi @himanshurauthan Many thanks for your input. This is what I thought was the case indeed. Would you know also why for deals in currencies other than the default company currency, the margin value from the line item doesn't get converted? It's only the revenue that gets converted (amount => amount in company currency), but margin stays in the original currency... 

[himanshurauthan]

Unfortunately @Edyta7510, this is a default functionality that cannot be changed.