Hi I'm trying to set the colour of the textbox dependant on the percentage value within it.
I have tried
=SWITCH(ReportItems!Textbox37.Value <= "91", "Red", ReportItems!Textbox37.Value <= "70","Orange",ReportItems!Textbox37.Value <= "100","Green",True,"Blue")
But this just returns all results in RED. regardless of the percentage value.
The result is derived from the following expression.
=sum(iif(Fields!QUALITY_CHECK.value<>3,1,0))/(RowNumber("dst_PERFORMANCE"))

