Multiple text color on report

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


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?


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

Example they give:


1 Like

Thanks…found it…