Multiple text color on report

I am using a dynamic key (data key is SDDEV.SD) for text color on a report successfully using…

STDDEV.SD>.3?“red”:“black”…

this works as expected, I want to add a third color and am struggling with the syntax

Trying various things like STDDEV.SD>3.5? “yellow”:STDDEV.SD>.5?“red”:“green”

Can this be done this way? is there a better way?

Thanks

The docs for Keychain expressions within the reporting system has a section on chaining conditionals.

Example they give:

@age>=21?"Adult":(age>12?"Teen":"Child")@.

1 Like

Thanks…found it…