24 Replies Latest reply: Jul 1, 2016 5:32 PM by PAUL YEO RSS

    Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

    PAUL YEO

      Hi All

       

      I copy the this KPI from QS example , i dont know how to make the % change to red color when % is +ve ? Now it display black color , i need to make it display Red color when -ve. Now alway black.

       

      I have try use the below expression , i insert at color value :-

      =if([Sales vs Target] <0% ,'#d01919','#545352')

       

      But it does not work.

       

      Paul