Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Visual efects with strings?

Hi i have an if/else condition and for result i have

"Ok"

"No Ok"

etc...

I tried in the vissual part efects and it works with numbers but i couldn't do this with the strings

it would be something like

IF(Status = 'Ok', Red(), Green()) or something like this

Greetings

1 Solution

Accepted Solutions
consenit
Partner - Creator II
Partner - Creator II

Hi there.

I never use visual effects because it's an obsolete feature; it's far better to enter the formula for color calculation below the main formula in the "Expression" tab, check out the treeview at the left side.

Kind regards,

Ernesto.

View solution in original post

3 Replies
NickHoff
Specialist
Specialist

You have to use double quotes:

IF(Status = 'Ok', "Ok","No Ok") AS Status

consenit
Partner - Creator II
Partner - Creator II

Hi there.

I never use visual effects because it's an obsolete feature; it's far better to enter the formula for color calculation below the main formula in the "Expression" tab, check out the treeview at the left side.

Kind regards,

Ernesto.

Not applicable
Author

Thank ya.