# Calculated Property Based on Static Number

**URL:** <https://community.hubspot.com/t/calculated-property-based-on-static-number/127746>\
**Category:** CRM\
**Tags:** enterprise\
**Created:** [March 11, 2025, 5:33pm UTC](https://community.hubspot.com/t/calculated-property-based-on-static-number/127746 "2025-03-11T17:33:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![KCole2523](https://avatars.discourse-cdn.com/v4/letter/k/e19adc/32.png) [@KCole2523](https://community.hubspot.com/u/KCole2523)\
**Post date:** [March 11, 2025, 5:33pm UTC](https://community.hubspot.com/t/calculated-property-based-on-static-number/127746/1 "2025-03-11T17:33:34Z")

</div>

Area: Deals

Purpose: Compare an input number to a static number to see if it is higher.

As part of minimum requirements to respond to a given RFP, I need to compare our insurance coverage to the required coverage.

For example:

My General Liability Coverage: $2,000,000

Required General Liability Coverage: $3,000,000

Can I create a property with a calculation field that if the required number (entered into the field) is equal to my coverage (nested in the formula), then the number stays the same? And if I am under the number, it will calculate the deficit and/or turn the number red to alert me to undercoverage?

Is an alternative to put our insurance coverage in our Hubspot record and ask it to compare to the input coverage for each deal?

---

<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 11, 2025, 5:38pm UTC](https://community.hubspot.com/t/calculated-property-based-on-static-number/127746/2 "2025-03-11T17:38:30Z")

</div>

Hi @KCole2523,

This can indeed be done with a calculation property: [Create calculation and rollup properties](https://knowledge.hubspot.com/properties/create-calculation-properties)

- Choose a custom equation
- Select output to be boolean
- Use an if statement to check whether your custom property \> your threshold

There is formula guidance both in the linked article and when you get errors in the editor. Let me know how it goes and if you have any follow-up questions!

---

<div class="post-metadata">

**Author:** ![KCole2523](https://avatars.discourse-cdn.com/v4/letter/k/e19adc/32.png) [@KCole2523](https://community.hubspot.com/u/KCole2523)\
**Post date:** [March 11, 2025, 7:53pm UTC](https://community.hubspot.com/t/calculated-property-based-on-static-number/127746/3 "2025-03-11T19:53:00Z")

</div>

I created the input field (Ins: Gen Liab per Occur) and mirrored the Boolean statement based on the example from Knowledge page (if([properties.number] \< 4, “less than four”, “more than four”) but it is not allowing me to test the formula.

 ![Screenshot 2025-03-11 at 1.23.50 PM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/c/3/c3588181b88678fc598c81c99ebe8f711f128c3b.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 11, 2025, 8:03pm UTC](https://community.hubspot.com/t/calculated-property-based-on-static-number/127746/4 "2025-03-11T20:03:32Z")

</div>

@KCole2523 click on the red dot “1 issue” to see instructions on what to fix and how. If you’re creating a Boolean, output should be true/false. If that’s not an option, change output to text.

Best regards!