Conditional Expressions are not permitted. Conditional behavior can be forced, when necessary, in two different ways.

IIF Function

{IIF(Condtion, ValueA, ValueB}

In the above calculation, the “Condition” is tested to determine if it evaluates to true or false. If it evaluates to true, the expression will return ValueA. If it evaluates to false, the expression will return ValueB .

Number of Cabinets: {Cabinet.Count > 0 ? Cabinet.Count : “None”}

If the value of Cabinet.Count is 3, the result in the report will be:

Number of Cabinets: 3

If the value of Cabinet.Count is 0, then the result in the report will be:

Number of Cabinets: None

C# Ternary Operator

In C#, you can use the ternary operator. For example:

{Condition ? ValueA : ValueB}

If “Condition” is true, the expression will return ValueA. If false, it will return ValueB.