Case statement with multiple field conditions
Hi - I'm looking for a Case statement that will provide multiple conditions and multiple "then" statements but keep getting an error. I've tried multiple versions but none have worked. Examples below: CASE(`Impact Rank`) WHEN <(`BDS Rank TW`)THEN CONCAT('<span style="background-color: #00A86B">','OUTPERFORMING') WHEN…