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.

[karstenkoehler · Accepted solution]

Hi @InnoVites,

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

Best regards!