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