Consider empty fields in a calculation as 0

HubSpot Ideas
41

agreed, this is needed. An ‘if empty’ function.

42

Please update this so empty numbers default to 0. So unintuitive and requires people to fill in unneccessary fields to see a calculation. I could see it being logical if there was a default value option so I could set all number fields to default to zero. But since that doesn’t exist this field is not very usable

43

@rwong Hey there! Do you know if the solution you proposed is possible using the “duration” option as a number format?

I created a “Total Time” property that sums the values of ten different “Cumulative Time” properties. However, the “Total Time” property won’t show me results unless all of the ten “Cumulative Time” properties are filled.

734×640 94.9 KB

44

ugh…yet another curious time-wasting Hubspot detail that may be obvious to professional coders, but to civilians, just trying to do a simple “add the value in these fields together” creates a head-scratcher when the result does not compute, yet the formula is shown as correct. sigh…

45

Another big +1 for this

46

Can you use is_known for this? I use it for string concatenation where there are null values but it might work with numbers too?

concatenate(if(is_known([properties.rc_sub_house]), [properties.rc_sub_house], ""), if(is_known([properties.rc_house_name]), [properties.rc_house_name], ""), if(is_known([properties.rc_street]), [properties.rc_street], ""), if(is_known([properties.rc_town]), [properties.rc_town], ""), if(is_known([properties.rc_county]), [properties.rc_county], ""), if(is_known([properties.rc_postcode]), [properties.rc_postcode], ""))

47

This is table stakes functionality.

The number of workflows we’ve had to build to cover functionality misses like this is ridiculous.

48

Is that a criticism towards HubSpot or my method of achieving this?

49

Hi everyone - Thank you all for taking the time to submit, vote and comment on this Idea. My name is Rachel, and I’m the PM for Properties.

Wanted to share an update here. We don’t currently have plans to build this. However, the if(is_known([property]), [property], 0) workaround is your best bet for handling null values as 0 in the formula editor today.

A chained if operators feature is actively in the works, which should give you much more flexibility in the formula builder.

50

+1000!
it would be great.

Upvote!

So sad it’s still not there (considering the date of the original message Apr’2020)