Hi,
I have a table with 3 columns “Real’17”, “Pto’17” and “% Pto” (which is just the column A (Real’17) divided by the column B (Pto’17)
I would like to show a simple KPI, when % Pto <0 then “Red”, when % Pto >0 then “Green” and when % Pto=0 then “Yellow” (Like the image)
But the problem is that this color code is different when the concept is “BAJAS”, it is to say, the other way around: when % Pto <0 then “Green”, when % Pto >0 then “Red”
How can I set two different KPI rules for a same dimension (Concepto) based on the concept I have?
I will be very grateful with any help
Many Thanks,
José
Hi Jose,
Just as a starter but to be complete all possible scenario's should be described.
KPI Var Pto:
IF [Var % Pto]>0 THEN "Green"
ELSEIF [Var % Pto]=0 THEN "Amarillo"
ELSEIF [Var % Pto]<0 and attr([Concepto])<>"BAJAS" THEN "Red"
ELSEIF [Var % Pto]<0 and attr([Concepto])="BAJAS" THEN "Green"
END
So let me know what should happen when attr([Concepto])="BAJAS" and [Var % Pto]=0 or [Var % Pto]>0....
Regards,Norbert
