how do you replace multiple items in report designer

Calcite | Level 5

how do you replace multiple items in report designer

Posted 08-12-2016 03:09 AM (1123 views)

I want to replace multiple items within a single field but CASE does not work and I cannot get REPLACE to replace more than one item a time. Any help on how do do this.

example for the lookup

1 = green

2 = red

3 = amber/green

4 = amber/red

1 REPLY 1

Barite | Level 11

Re: how do you replace multiple items in report designer

Posted 08-12-2016 03:21 AM (1121 views) | In reply to NCR

Can you please elaborate

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!