Equation based on the equation of connection

Ask the Community Get Answers
1

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.

image
image635×750 43.9 KB

2

HI

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

if condition ? then this : else this

Craig

3

This dives into more detail.

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

4

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