# Create multiple conditions in a calculated field

**URL:** <https://community.hubspot.com/t/create-multiple-conditions-in-a-calculated-field/20622>\
**Category:** CRM\
**Created:** [May 6, 2020, 6:56am UTC](https://community.hubspot.com/t/create-multiple-conditions-in-a-calculated-field/20622 "2020-05-06T06:56:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![MatP](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/matp/32/98997_2.png) [@MatP](https://community.hubspot.com/u/MatP)\
**Post date:** [May 6, 2020, 6:56am UTC](https://community.hubspot.com/t/create-multiple-conditions-in-a-calculated-field/20622/1 "2020-05-06T06:56:06Z")

</div>

Hello,

I have the following Use Case: I’m trying to create “Current Year Turnover” and “Previous Year Turnover” fields as company properties. I’ve created calculated fields for these taking the sum of all transaction amounts. However I need a double criteria or condition on these fields: The year and the state of the transaction. Currently it seems I can only define one criteria:

 ![img.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/8/8/8802af19e4b4fb232285f005b6e821a0e364de6e.png)

Is there really a limitation on only one criteria or am I missing something? Is there a workaround on how to add another condition?

Thank you in advance for your help!

MatP

---

<div class="post-metadata">

**Author:** ![JessicaH](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jessicah/32/14826_2.png) [@JessicaH](https://community.hubspot.com/u/JessicaH)\
**Post date:** [May 8, 2020, 11:19am UTC](https://community.hubspot.com/t/create-multiple-conditions-in-a-calculated-field/20622/2 "2020-05-08T11:19:29Z")

</div>

Hi @MatP,

Thanks for reaching out.

At the moment you can only add one condition.

However, there’s already [an idea in our ideas forum](https://community.hubspot.com/t5/HubSpot-Ideas/Allow-Multiple-Conditions-for-Calculated-Properties-of-Type/idi-p/313564).

It’s a forum which is made for users to submit new ideas. The community can vote and comment and HubSpot evaluates the ideas and takes them into consideration for new product updates.

If you want to get updates I would encourage you to participate in this post by upvoting and commenting on the post.

Take care!

Jess

---

<div class="post-metadata">

**Author:** ![MonkeyWork21](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/monkeywork21/32/194828_2.png) [@MonkeyWork21](https://community.hubspot.com/u/MonkeyWork21)\
**Post date:** [May 6, 2022, 9:21pm UTC](https://community.hubspot.com/t/create-multiple-conditions-in-a-calculated-field/20622/3 "2022-05-06T21:21:45Z")

</div>

Yes if you could please add this it would be great. Right now, the calculated properties are extremely limited / basic and this would greatly enhance the power of Hubspot as well as solve various other common issues that have been raised on these idea forums (e.g., the multi-currency reporting issue).

---

<div class="post-metadata">

**Author:** ![DianaGomez](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dianagomez/32/48035_2.png) [@DianaGomez](https://community.hubspot.com/u/DianaGomez)\
**Post date:** [May 7, 2022, 2:15am UTC](https://community.hubspot.com/t/create-multiple-conditions-in-a-calculated-field/20622/4 "2022-05-07T02:15:20Z")

</div>

Hi @MonkeyWork21 thank you for your feedback.

I encourage you to upvote the [idea](https://community.hubspot.com/t5/HubSpot-Ideas/Allow-Multiple-Conditions-for-Calculated-Properties-of-Type/idi-p/313564), this way it will have more chances to be implemented in the future.

Best,

Diana