Unexpected formula behaviour in calculated property

InnoVites
Participante

Hi,
I am creating a calculated property but the formula does not execute as expected. You can see two versions of the formula (i tried many versions) but none of them seem to work as expected. The goal is that the formula returns the amount in company currency if no ARR is available and the pipeline equals the renewals pipeline. The formula only returns a blank value.

Thanks in advance for your thoughts and ideas.

Screenshot 2025-10-08 at 08.30.35.pngScreenshot 2025-10-08 at 08.30.21.pngScreenshot 2025-10-08 at 08.22.40.png

0 Me gusta
1 Soluciones aceptada
karstenkoehler
Solución
Miembro del salón de la fama | Partner
Miembro del salón de la fama | Partner

Hi @InnoVites,

 

The formula expects the internal label of the deal stage, not the display name:

 

karstenkoehler_0-1759905734643.png

 

Best regards!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

Ver la solución en mensaje original publicado

1 Respuesta 1
karstenkoehler
Solución
Miembro del salón de la fama | Partner
Miembro del salón de la fama | Partner

Hi @InnoVites,

 

The formula expects the internal label of the deal stage, not the display name:

 

karstenkoehler_0-1759905734643.png

 

Best regards!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.