HubSpot does not automatically set a value of 0 for empty fields. If any of the number properties used in a custom equation have no value, the calculated property value will be empty.
Yes, or at least allow calculations to occur in workflows (rather than just increasing properties by a static value). Because "if any of the number properties used in a custom equation have no value, the calculated property value will be empty" we can't collate number properties into a single property, which would be really useful.
This is a pretty big deal. Surprised it hasn't gotten more upvotes. We have to type in so much extra 0's for calculation fields to show up. We use this for our amount field in deals. All our reps have to go through all our revenue types and put 0's if there isn't an actual revenue number to put there. If they don't fill it in it makes their sales numbers look a lot worse than they should. Please fix!
Depending on the subscription level (Workflows help in this instance), one potential workaround is to ensure that any custom properties required for a calculation property are specifically set to a zero value as opposed to blank.
A workflow triggered by the custom property having a value of 'unknown' with an action to set the property to '0' or '$0' will support that property being used in a calculation property.
I'm not sure if this solves for any of the use cases in this thread but thought I'd share.
Trying to generate a report that uses Time In Stage. Sometimes, a Deal gets dropped into a Stage accidentally (eg Closed Won), and I don't want to count those few seconds, so I need my report to look at deals where time in that stage is less than a few min OR (of course!) never in that stage at all. Can't do that today because "never in that stage" is "unknown" instead of 0. Very frustrating and is now forcing me to do some crazy hack to build my own calculated value so I can have a single property where "never in that stage" is treated as 0.