Equation based on the equation of connection

[RCB]

Hi wonderful people, just wanted to get your advice on my equation. Here’s my equation:

{Category ClientName.FinancialYearNum} == 2025 ? {Category Categories_MinFee.Categories_MinFee_2025} * {Quantity}

Basically, the {Category ClientName.FinancialYearNum} is an equation from the connection table. I am wondering why there is an error to it.

Thanks in advance.

[CSWinnall]

HI

You are missing the else part of the equation. Ternary should follow this format:

if condition ? then this : else this

Craig

[CarlHolmes]

This dives into more detail.

About Equations

As @CSWinnall said, you just need the false part of the equation.

[RCB]

Hi @CSWinnall and @CarlHolmes, thanks and it worked like a charm.