HubSpot Ideas

Brownstephen101

Allow Calculated fields to be defaulted to 0, so they don't break dependent calculated fields.

Right now, if you have two calculated fields, and one is using the other to generate it's sum. If the first field does not have a value (IE: a rolllup of associated deal values to a company, before any deals are created for that company), then the dependant field will be null as well, even if the first field is being subtract from some other value.

For example, what we are experiencing is similar to:

x = first_calc_field

1000 - x = null <-- This is what happens
1000 - x = 1000 <-- This would be preferable

If it's not the default, than just a boolean that we can select for if we want the value to default to 0 instead of null would be great, so that we can build additional calculations off of it.

8 Comentários
danmoyle
Participante de valor | Parceiro Elite

This would be great for complex situations - great idea @Brownstephen101 

vanessahunt
Top colaborador(a) | Parceiro Platinum

@Brownstephen101 I had a similar situation with a client, which was causing us some frustration 😋

 

P.S. I created a workaround in the interim - used workflow  to 'copy 'the value of the calculated property into another property, and where the value was null, set the 'duplicate' property's value to zero with workflow. And then used the 'cloned' property in the main calculation. This worked for our simple use case, but a bit crazy for what should be relatively straightforward maths. 

cjkappen
Participante | Parceiro Diamante

We can't accomplish our use case without this feature in any scalable way currently. Come on HubSpot, you can do this!

RLong8
HubSpot Employee

+1 this has definitely come up a few times for customers who are using multiple calc properties together

LUlrich1
Membro

+1

MaorL
Participante

Solved
MaorL_0-1692942395226.png

 

ALevine2
Participante

@MaorL how would you identify a specific sales pipeline

jjones41
Colaborador(a)

100% on this. Also, would be good to note there is at least one duplicate for this idea:
https://community.hubspot.com/t5/HubSpot-Ideas/Consider-empty-fields-in-a-calculation-as-0/idi-p/331...