Tips, Tricks & Best Practices

dmattauch
Top Contributor

Calculate the number of deals that have a certain property inside a company record

SOLVE

Hey,

 

There's probably a easy solution but i can't find a way to do that with workflow.

 

Inside my deals i created a yes/no property. let's call this property X

 

If my company has several deals, i want to know the number of deals that have the value "yes" for the property X

 

When i create a deal-based workflow the option "increase or decrease value property" is only available for deals, not for the company record. 

 

Any ideas ?

 

Thanks

David

0 Upvotes
1 Accepted solution
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Calculate the number of deals that have a certain property inside a company record

SOLVE

Hi @dmattauch,

 

If you have access to workflows, you should also have access to calculation properties which we can use here.

 

You'd create a company-based calculation property which looks like this:

 

karstenkoehler_0-1628848161344.png

 

Let me know if you have a follow-up question!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

View solution in original post

2 Replies 2
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Calculate the number of deals that have a certain property inside a company record

SOLVE

Hi @dmattauch,

 

If you have access to workflows, you should also have access to calculation properties which we can use here.

 

You'd create a company-based calculation property which looks like this:

 

karstenkoehler_0-1628848161344.png

 

Let me know if you have a follow-up question!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

dmattauch
Top Contributor

Calculate the number of deals that have a certain property inside a company record

SOLVE

oh perfect thank you