# Calculation rolling revenue(in Year)

**URL:** <https://community.hubspot.com/t/calculation-rolling-revenue-in-year/82825>\
**Category:** Dashboards & Reporting\
**Tags:** reports\
**Created:** [June 7, 2023, 8:54am UTC](https://community.hubspot.com/t/calculation-rolling-revenue-in-year/82825 "2023-06-07T08:54:06Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![HFisher7](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/hfisher7/32/101931_2.png) [@HFisher7](https://community.hubspot.com/u/HFisher7)\
**Post date:** [June 7, 2023, 10:23am UTC](https://community.hubspot.com/t/calculation-rolling-revenue-in-year/82825/2 "2023-06-07T10:23:52Z")

</div>

@samike - A few ways I can think of achieving this..

- Use the recurring revenue report in HubSpot: [Track recurring revenue in HubSpot](https://knowledge.hubspot.com/deals/track-recurring-revenue-with-revenue-analytics)
- Build a dataset to calculate the number of months between the billing start date and today’s date and multiple the line items MRR by this: [Create and use datasets](https://knowledge.hubspot.com/reports/create-and-use-datasets)
- Create a custom-coded workflow action that calculates the time in months between the ‘Billing start date’ and ‘Today’s date’ and copies the value across to a custom ‘Months active’ number property. Create a calculation property that multiples the value in ‘Months active’ and the value in the ‘MRR’: [Create workflows](https://knowledge.hubspot.com/workflows/create-workflows) & [Create calculation properties](https://knowledge.hubspot.com/crm-setup/create-calculation-properties)

N.B Option 2 & 3 require use to create a ‘Today’s date’ property that enrolls into a workflow every day and stamps the property with the date of the step.

---

_[View the full topic](https://community.hubspot.com/t/calculation-rolling-revenue-in-year/82825)._
