# Rollup field is empty

**URL:** <https://community.hubspot.com/t/rollup-field-is-empty/103198>\
**Category:** Tips, Tricks & Best Practices\
**Tags:** crm, object\
**Created:** [March 22, 2024, 11:44am UTC](https://community.hubspot.com/t/rollup-field-is-empty/103198 "2024-03-22T11:44:03Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![TShemesh8](https://avatars.discourse-cdn.com/v4/letter/t/f04885/32.png) [@TShemesh8](https://community.hubspot.com/u/TShemesh8)\
**Post date:** [March 22, 2024, 11:44am UTC](https://community.hubspot.com/t/rollup-field-is-empty/103198/1 "2024-03-22T11:44:03Z")

</div>

Hi all, I created a rollup property for MRR as we have certain products that are not considered recurring and I couldn’t use the standard MRR property.

The property seems to be working well on new deals - when I add a line item it makes the calculation. My problem is with existing deals - it doesn’t seem to be working and the property remains empty. Is there a way to enrol all deals to the property?

Thanks,

Tom

---

<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:** [March 22, 2024, 11:45am UTC](https://community.hubspot.com/t/rollup-field-is-empty/103198/2 "2024-03-22T11:45:18Z")

</div>

Hi @TShemesh8,

Can you please share a screenshot of your calculation property settings?

Best regards

---

<div class="post-metadata">

**Author:** ![TShemesh8](https://avatars.discourse-cdn.com/v4/letter/t/f04885/32.png) [@TShemesh8](https://community.hubspot.com/u/TShemesh8)\
**Post date:** [March 22, 2024, 11:53am UTC](https://community.hubspot.com/t/rollup-field-is-empty/103198/3 "2024-03-22T11:53:32Z")

</div>

sure!

I also did a test and created a new deal with the exact same products, terms and pricing as an existing deal. In the new deal the new property was populated while in the existing deal it wasn’t. I tried editing the line items in the existing deal in the hopes it would tiger the rollup but it didn’t.

 ![TShemesh8_0-1711107986445.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/c/e/ceebaff176db3c87ae3f8fe151acc68a5e98be36.png)

---

<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:** [March 22, 2024, 11:55am UTC](https://community.hubspot.com/t/rollup-field-is-empty/103198/4 "2024-03-22T11:55:01Z")

</div>

@TShemesh8 I’m not seeing an obvious mistake in how this is set up or tested - I think the fastest way to resolve this would be for you to reach out to HubSpot support in-app 🙂

---

<div class="post-metadata">

**Author:** ![TShemesh8](https://avatars.discourse-cdn.com/v4/letter/t/f04885/32.png) [@TShemesh8](https://community.hubspot.com/u/TShemesh8)\
**Post date:** [April 2, 2024, 11:06am UTC](https://community.hubspot.com/t/rollup-field-is-empty/103198/5 "2024-04-02T11:06:24Z")

</div>

Hi all, I wanted to give an update and ask another question:

I reached out to HS support, was not helpful at all, didn’t understand the problem after multiple emails. In the end, it was a sales ops friend who theorized that maybe deals that were created before the rollup field weren’t updated because the filter I have (recurring = yes/no) is blank on those deals.

After a quick check - that is correct - I updated a property on the product level for each product to say whether they were recurring or not. I didn’t expect that these properties would remain empty on existing line items. Now I need to update all the line items with this data.

I have tried:

- Workflow - started great but I can’t add an action to change a property on the line item (only deals and other related objects for some reason).

- Exporting a report - can’t export line item reports.

- Mass update on a view - can’t view line item properties on deal view.

Does anyone have a way for me to mass update a field on existing line items without having to go one by one?

Thanks,

Tom
