# Multiply fields by conditional numbers

**URL:** <https://community.hubspot.com/t/multiply-fields-by-conditional-numbers/67565>\
**Category:** HubSpot Ideas\
**Tags:** object\
**Created:** [October 20, 2022, 4:19pm UTC](https://community.hubspot.com/t/multiply-fields-by-conditional-numbers/67565 "2022-10-20T16:19:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![CBrody](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/cbrody/32/28756_2.png) [@CBrody](https://community.hubspot.com/u/CBrody)\
**Post date:** [October 20, 2022, 4:19pm UTC](https://community.hubspot.com/t/multiply-fields-by-conditional-numbers/67565/1 "2022-10-20T16:19:36Z")

</div>

I’m trying to figure out a way to create a new field on the “deal” object that takes the “amount” field and multiplies it by a certain number depending on what’s selected in the “forecast category” field (e.g., if “forecast category” = “commit”, then multiply “amount” by .75 and put that value in “forecast category weighted amount” field). I spoke with HubSpot support, and this isn’t possible to do at this time. It would be great to be able to use if/then statements to calcuate fields via a custom field creation and/or a workflow.

---

<div class="post-metadata">

**Author:** ![NGutgsell](https://avatars.discourse-cdn.com/v4/letter/n/4da419/32.png) [@NGutgsell](https://community.hubspot.com/u/NGutgsell)\
**Post date:** [December 14, 2022, 11:04am UTC](https://community.hubspot.com/t/multiply-fields-by-conditional-numbers/67565/2 "2022-12-14T11:04:33Z")

</div>

great Idea! We are looking for something similar.

---

<div class="post-metadata">

**Author:** ![WShadwell](https://avatars.discourse-cdn.com/v4/letter/w/f6c823/32.png) [@WShadwell](https://community.hubspot.com/u/WShadwell)\
**Post date:** [April 18, 2023, 5:12pm UTC](https://community.hubspot.com/t/multiply-fields-by-conditional-numbers/67565/3 "2023-04-18T17:12:08Z")

</div>

+1 to this!

Being able to use if/then logic opens up the power of the CRM to a completely different level. I’d like to be able to calculate estimated revenue based upon many different factors…

if _customer type 1_ then…

if _purchase price_ \>= X then…

- Dropdown Menu ABC = _high price model_

_- estimated revenue = (purchase price - (purchase price \* discount amount) ) \* Commission_

```
if *purchase price <=X then...*

```

- Dropdown Menu ABC = _low price model_

_- estimated revenue = (purchase price \* Commission)_

_if customer type 2 and purchase price \>= X then …_

_… And_ so on and so forth. Having this much control to use the properties in unique ways is a game changer to being able to do massive amounts of calculations and decisions that can create HIGHLY personalized structures for a variety of clients. If Hubspot implements this, they’re able to become the most customizable CRM ever.