# Additional Condition filter on rollup missing properties

**URL:** <https://community.hubspot.com/t/additional-condition-filter-on-rollup-missing-properties/128131>\
**Category:** Tips, Tricks & Best Practices\
**Tags:** enterprise\
**Created:** [March 17, 2025, 10:04pm UTC](https://community.hubspot.com/t/additional-condition-filter-on-rollup-missing-properties/128131 "2025-03-17T22:04:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vetromark](https://avatars.discourse-cdn.com/v4/letter/v/cc9497/32.png) [@Vetromark](https://community.hubspot.com/u/Vetromark)\
**Post date:** [March 17, 2025, 10:04pm UTC](https://community.hubspot.com/t/additional-condition-filter-on-rollup-missing-properties/128131/1 "2025-03-17T22:04:29Z")

</div>

Can anyone tell me what makes some properties unavailable in the Additional Condition filter of a rollup property? I created a calculation field on the deal record to indicate if it is an active deal or not, and it returns true/false. I’m trying to use this field as the Additional Condition to rollup data on the company record for active deals, but the property isn’t available. I can select other true/false fields, and other calculated fields. What would be making this field unavailable?

---

<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 18, 2025, 4:28am UTC](https://community.hubspot.com/t/additional-condition-filter-on-rollup-missing-properties/128131/2 "2025-03-18T04:28:19Z")

</div>

Hi @Vetromark,

I’m not sure if this is documented but last I checked, I experienced the same and HubSpot might simply not allow calculation properties to be referenced within calculation properties. If you translate this into a regular single checkbox property (e.g. via workflow), you should find it work.

Best regards!

---

<div class="post-metadata">

**Author:** ![paulcmaxwell](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/paulcmaxwell/32/56462_2.png) [@paulcmaxwell](https://community.hubspot.com/u/paulcmaxwell)\
**Post date:** [March 19, 2025, 2:11pm UTC](https://community.hubspot.com/t/additional-condition-filter-on-rollup-missing-properties/128131/3 "2025-03-19T14:11:00Z")

</div>

It is possible that:

1. Other true/false fields are standard HubSpot fields, and
2. Other calculation fields output numerical values, but that
3. HubSpot does not allow Boolean output calculation properties to be used as rollup property conditions.

Have you checked:

1. The output is set appropriately (It is Boolean, not String)
2. Actual values of the calculation field have populated on deals
3. The property is available in reports.
4. You are applying the correct operator -- meaning, if you have a mathematical operator selected (equals), it will not allow you to select a non-number field.