A customer wanted a conditional hyperlink.
If the turnover was greater then 100000 it should show a hyperlink else only the number
Till Next Time
Here is how we did it:
CASE WHEN ("F1 Revenue"."1-01 Revenue (Sum All)"> 100000 )THEN '{a href=http://www.google.com }'CAST("F1 Revenue"."1-01 Revenue (Sum All)" as VARCHAR(10)) '{/a}' else CAST( "F1 Revenue"."1-01 Revenue (Sum All)" as VARCHAR(10) )END
Don't forget to set the column data type settings:
Till Next Time
