# Workflow for closed lost deals

**URL:** <https://community.hubspot.com/t/workflow-for-closed-lost-deals/62836>\
**Category:** CRM\
**Created:** [August 11, 2022, 4:35pm UTC](https://community.hubspot.com/t/workflow-for-closed-lost-deals/62836 "2022-08-11T16:35:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![LLuik](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/lluik/32/68311_2.png) [@LLuik](https://community.hubspot.com/u/LLuik)\
**Post date:** [August 11, 2022, 4:35pm UTC](https://community.hubspot.com/t/workflow-for-closed-lost-deals/62836/1 "2022-08-11T16:35:17Z")

</div>

Hello HubSpot Community!

I am new to the HS world and trying to set up a workflow where if a deal is closed lost the ARR property on the company level will be set to $0. The issue is that if a sales rep has 2 deals for that company and one is lost and the other won, I do not want the ARR field to be $0. Anyone run into something like this and have a solution?

Thanks!

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [August 11, 2022, 4:41pm UTC](https://community.hubspot.com/t/workflow-for-closed-lost-deals/62836/2 "2022-08-11T16:41:28Z")

</div>

Hi @LLuik,

You could leverage calculation properties here. [Calculation properties](https://knowledge.hubspot.com/crm-setup/create-calculation-properties) can count how many associated records match certain criteria. In this case, you would count on the company record how many associated won deals there are:

 ![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/0/f/0f7694bba4234d1bd598cc1937f84b9f7351b2b5.png)

You can then adjust your deal workflow to only set the property to $0 when this company calculation property has the value 0 🙂 (This would be included in the deal workflow enrollment criteria: value of associated company’s calculation property is 0.)

Let me know if you have any follow-up questions!
