Unexpected formula behaviour in calculated property

InnoVites
参加者

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 いいね!
1件の承認済みベストアンサー
karstenkoehler
解決策
殿堂入り | Solutions Partner
殿堂入り | Solutions 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.

元の投稿で解決策を見る

1件の返信 1
karstenkoehler
解決策
殿堂入り | Solutions Partner
殿堂入り | Solutions 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.