topic Re: Calculated fields return null values in Data Hub

Calculated fields return null values

Huntscape-Ops — Mon, 07 Apr 2025 18:08:28 GMT

I am trying to use a calculated field, but if one of the values is empty in the calculation, then it returns a null value.

([properties.imported_total] + [properties.total_donations])

There has to be an easy way to fix this but chatgpt is telling me to use ops hub (which is fine) and use this formula in the format data step of the workflow: {{ properties.imported_total | default(0) }} + {{ properties.total_donations | default(0) }}

But that causes an error in the custom code step. Please help

Re: Calculated fields return null values

karstenkoehler — Mon, 07 Apr 2025 18:14:15 GMT

Hi @Huntscape-Ops,

You can solve this with an 'if' statement and the 'is known' function, both available through drop downs in the formula editor - no Operations Hub required. If the number is known, return the number, if not, return a 0. Repeat the same for the second part of the calculation and that should do the trick.

Best regards

Re: Calculated fields return null values

Huntscape-Ops — Mon, 07 Apr 2025 18:38:02 GMT

Thank you for the quick reply but I am not advanced enough to do that. I
keep getting errors in the calculation

Re: Calculated fields return null values

karstenkoehler — Mon, 07 Apr 2025 18:46:04 GMT

@Huntscape-Ops can you please share a screenshot? If you type the shown formula exactly, you shouldn't get any errors.

Re: Calculated fields return null values

Huntscape-Ops — Mon, 07 Apr 2025 18:49:42 GMT

This is my original calculation but it puts out null value when one of the fields is empty.

I have no idea how to adapt this to "if" and "is known" as you were describing.

Any help would be greatly appreciated

Re: Calculated fields return null values

karstenkoehler — Mon, 07 Apr 2025 18:52:42 GMT

@Huntscape-Ops there's no special trick to this - just find the screenshot I shared in my earlier reply and type that exactly into the formula field, character by character 🙂

Re: Calculated fields return null values

Huntscape-Ops — Mon, 07 Apr 2025 19:01:14 GMT

I lied. The formula no longer has errors but I am still getting null values in the calculated field

Re: Calculated fields return null values

karstenkoehler — Mon, 07 Apr 2025 19:02:51 GMT

@Huntscape-Ops can you please share a screenshot and the error message? I can't help if I don't have any details.

Re: Calculated fields return null values

Huntscape-Ops — Mon, 07 Apr 2025 19:04:37 GMT

Does this help

Re: Calculated fields return null values

Huntscape-Ops — Mon, 07 Apr 2025 19:07:02 GMT

Wow that worked. I had 1 space off.

Thank you so much

Re: Calculated fields return null values

karstenkoehler — Mon, 07 Apr 2025 19:08:33 GMT

@Huntscape-Ops strange - can you save this and see if it populates correctly on records? It should work, see my screenshot. If it doesn't after refreshing, I'd recommend checking with HubSpot support.

Re: Calculated fields return null values

Huntscape-Ops — Mon, 07 Apr 2025 19:10:50 GMT

I refreshed the screen and put the formula back in, and it is working now.

Thank you so much