# Calculated properties

**URL:** <https://community.hubspot.com/t/calculated-properties/117427>\
**Category:** CRM\
**Tags:** crm, professional, how-to\
**Created:** [October 1, 2024, 11:45am UTC](https://community.hubspot.com/t/calculated-properties/117427 "2024-10-01T11:45:33Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![jnix284](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jnix284/32/29_2.png) [@jnix284](https://community.hubspot.com/u/jnix284)\
**Post date:** [October 1, 2024, 7:26pm UTC](https://community.hubspot.com/t/calculated-properties/117427/3 "2024-10-01T19:26:14Z")

</div>

Happy to help @kennedyp, @SBencheikh you can use this as a starting point, I used [Hub Helper Harry](https://chatgpt.com/g/g-S1yvJO3I6-hub-helper-harry) a chatGPT trained on HubSpot and a great tool for solving questions like this.

### Steps to Calculate Recognized Revenue for the Current Year:

1. **Define the Inputs** (these are your existing properties)

2. **Calculate the Duration of the Contract:**

3. **Divide the Total Contract Value Over the Duration:**

4. **Identify the Portion Recognized for the Current Year:**

5. **Create the Formula in HubSpot:**

Here is a sample formula you could apply:

`(Total Contract Value) / DATEDIFF('End Date', 'Start Date', 'months') * DATEDIFF('31/12/CurrentYear', '01/07/2024', 'months')`

- You might need to adjust the formula based on how HubSpot handles date properties and whether you’re working in months or days for accuracy.
- You can apply similar logic to calculate revenue for subsequent years based on the contract duration.

I would recommend simplifying your example to create a base formula without all of the variables (like whether it starts at the beginning of the year vs mid-year, etc.) with your defined criteria (days vs months) and then running some tests to validate the formula.

If you are looking for someone to provide you with the exact formula it might be best to pursue paid services from a consultant/freelancer or a partner/agency.

---

_[View the full topic](https://community.hubspot.com/t/calculated-properties/117427)._