Create multiple conditions in a calculated field

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:

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

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.

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

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).

Hi @MonkeyWork21 thank you for your feedback.

I encourage you to upvote the idea, this way it will have more chances to be implemented in the future.

Best,

Diana