I have been struggling to create a Traffic light gauge in a straight table.
What I would like to have, is a traffic light indicating the below.
IF([Variance] >0 and [Variance] <1,YELLOW()
IF([Variance]>1 , GREEN())
Variance the label name for an expression which calculates the variance between actual and budget values. I get an error when creating a IF statement like the above, saying that there's an invalid token.
Nonetheless, I would really love to just have a 3 segment traffic light gauge, where the colours are based on the above.