• Substitute IIF( for IF, a comma for THEN and another comma for ELSE and place a close paren ')' at the end.

    IIF syntax is IIF( check expression, true expression, false expression)

    You will also want to strip out the { and } around the field names and use SSRS conventions for the fields Fields!fieldname.Value

    HTH

    [font="Comic Sans MS"]toolman[/font]
    [font="Arial Narrow"]Numbers 6:24-26[/font]