How to Create a Contact Field with the Total Income of Yearly Deals

Canonjuan
Member

Hi Hubspot Community!

 

I want to create a contact field that displays the total income related to deals closed this year (or in any other time lapse). Does anybody know how to do this? This fields is important for creating a multi-tiered VIP program associated with the yearly deals of the contacts. 

0 Upvotes
1 Accepted solution
MFrankJohnson
Solution
Thought Leader

_hubspot-button-accept-as-solution-gif-v00.gif

 

Q:  We want to create a contact field that displays the total income related to deals closed this year (or in any other time lapse). Does anybody know how to do this??

 

Short A: Deal Total? Yes, if you use HubSpot Enterprise. | Limited to timeframe? No.

 

Longer A:

Create a HubSpot custom Company property (type = Calculation) using the following formula settings.

- see image

HubSpot Company Deal Total (Type = Calculation)HubSpot Company Deal Total (Type = Calculation)

 

This custom Company property will auto-calculate the Deal total for all deals associated with the company. This custom Company property can be used as workflow enrollment criteria and as a personalization token in email.

 

Unfortunately, we are unable to limit the calcuation to a specific timeframe at this time.

 

Help answer your question? If so, remember to accept this solution now.

 

Best,
Frank

Author, the Perfect HubSpot Series


hubspot-solutions-signature-mfrankjohnson-v05.png

MFrankJohnson.com | Connect on LinkedIn

Help find posts quickly ... accept this solution now.

 

Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.

 

Hope that helps.

 

Be well,
Frank


www.mfrankjohnson.com

View solution in original post

0 Upvotes
1 Reply 1
MFrankJohnson
Solution
Thought Leader

_hubspot-button-accept-as-solution-gif-v00.gif

 

Q:  We want to create a contact field that displays the total income related to deals closed this year (or in any other time lapse). Does anybody know how to do this??

 

Short A: Deal Total? Yes, if you use HubSpot Enterprise. | Limited to timeframe? No.

 

Longer A:

Create a HubSpot custom Company property (type = Calculation) using the following formula settings.

- see image

HubSpot Company Deal Total (Type = Calculation)HubSpot Company Deal Total (Type = Calculation)

 

This custom Company property will auto-calculate the Deal total for all deals associated with the company. This custom Company property can be used as workflow enrollment criteria and as a personalization token in email.

 

Unfortunately, we are unable to limit the calcuation to a specific timeframe at this time.

 

Help answer your question? If so, remember to accept this solution now.

 

Best,
Frank

Author, the Perfect HubSpot Series


hubspot-solutions-signature-mfrankjohnson-v05.png

MFrankJohnson.com | Connect on LinkedIn

Help find posts quickly ... accept this solution now.

 

Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.

 

Hope that helps.

 

Be well,
Frank


www.mfrankjohnson.com
0 Upvotes