Hello!
I have a trouble, i am creating some traffic light in order to determine where is the level of the indicators. There are 4 fields.
Unacceptable, Deficient, Target and outstanding.
The first light turns red if the data is lower that the minimum level. and if it is higher than the minimum level but lower than the average it will be white. Here is the code:
If([KPI's de Incid 1]<[Límite inferior],Red(), White())
Average= 6 Minimum Level= 3 Data= 2
Now if the level is lower than the average but is higher than the minumum level it must be yellow.
If([KPI's de Incid 1]<Media,Yellow(),White())
Average= 6 Minimum Level= 3 Data= 4
Here is my question, i want to only see the red light if the data is lower than my lower minimum, actually ithe code works but if the data is for example 4 the two lights turn on, the yellow and the red one.
Any ideas how can i fix it? Also i have to do the same for the Average and the Higher Level
Thank you!
