# Formula fields

**URL:** <https://community.hubspot.com/t/formula-fields/118015>\
**Category:** CRM\
**Tags:** starter\
**Created:** [October 9, 2024, 5:03pm UTC](https://community.hubspot.com/t/formula-fields/118015 "2024-10-09T17:03:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![CClark3](https://avatars.discourse-cdn.com/v4/letter/c/87869e/32.png) [@CClark3](https://community.hubspot.com/u/CClark3)\
**Post date:** [October 9, 2024, 5:03pm UTC](https://community.hubspot.com/t/formula-fields/118015/1 "2024-10-09T17:03:00Z")

</div>

Hello,

I’m having an issue with formula fields. I want a field that tracks funding we get from partners to help with deals. So what I need is if a partner gives 20k on a deal worth a 100k for the client portion field be populated automatically with 80k So amount-Partner funding. Partner funding is not on all deals so it would be if this field is known. When I try to create this formula I get an error but not understanding why. This is the formula I’m trying. Could any one help to see what I’m missing?

if(is\_known([properties.partner\_funding]),([properties.amount\_in\_home\_currency] -[properties.partner\_funding]),0)

---

<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:** [October 9, 2024, 5:51pm UTC](https://community.hubspot.com/t/formula-fields/118015/2 "2024-10-09T17:51:46Z")

</div>

Hi @CClark3,

Could you please share a screenshot of the entire configuration, including calculation type etc and ideally the exact error message?

Best regards

---

<div class="post-metadata">

**Author:** ![CClark3](https://avatars.discourse-cdn.com/v4/letter/c/87869e/32.png) [@CClark3](https://community.hubspot.com/u/CClark3)\
**Post date:** [October 9, 2024, 8:18pm UTC](https://community.hubspot.com/t/formula-fields/118015/3 "2024-10-09T20:18:40Z")

</div>

Hello,

Yes I’ve attached a copy of the formula I used

 ![Partnerfunding (1).PNG](https://d2qpr2jzcazej7.cloudfront.net/original/3X/6/d/6da150428984f84f902960503f2b71d522344e36.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:** [October 10, 2024, 4:02am UTC](https://community.hubspot.com/t/formula-fields/118015/4 "2024-10-10T04:02:56Z")

</div>

@CClark3 it looks like there are two issues:

- “If” needs to be lowercase “if”
- “Partner funding” doesn’t seem to be a number property

You can try to convert the “Partner funding” string to a number using this function:

 ![karstenkoehler_0-1728532966628.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/6/2/620b8889bcc43458d4250c681007944e5b178a91.png)