Has anyone been able to apply conditional formating for a dynamic value?

I know you can do:
DEFMACRO=COND0001,
MACTYPE=RULE,
WHEN=N5 EQ N3, or you can use WHEN N5 EQ 'Totals'

However I have a dynamic value for a Team Name plus a constant of "Totals". I've tried
DEFMACRO=COND0001,
MACTYPE=RULE,
WHEN=N5 EQ (N3 + ' Totals')
and
WHEN=N5 EQ (team_name + ' Totals') -*team_name is the original column name

and other variations with the ticks and quotes and parentheses.

Anyone have any ideas?

Thanks,
Jason

The manual is clear on this point, the value on the right of the operand must be a constant or field in the report, and functions (e.g. concateneting a field and a constant) cannot be used.

The best approach is to use a DEFINE or COMPUTE in your report, with the NOPRINT option, and use that within the WHEN clause.

e.g.
.
.
COMPUTE CHECK/A1=IF field1 EQ field2 | 'constant' THEN 'Y' ELSE 'N'; NOPRINT
.
.
WHEN=CHECK EQ 'Y',
.
.

Nice work around. I didn't even know that there was a concatenate function in WF. Makes total sense...after you showed me!

Thanks for the help.