2 Replies Latest reply: Feb 2, 2016 10:03 AM by PAUL YEO RSS

    Convert 3 color script to 4 color for GP%

    PAUL YEO

      Hi All

       

       

      After finish my work , i manage to think better and able to know what i want , So I think better i start a new posting , since my requirement have change.

       

       

      I have the condition is below :- 

       

       

      GP < 25 %  Color Red

      GP <35 % >25% Green color

      GP >35% Yellow

       

       

      Mr Sutte give me the below script , which is working fine :-

       

       

      If(GP% > 0.35,Yellow()

        ,If(GP% < 0.25, Red(), Green())

        )

       

      Now I need to change the condition to add one more color for Organ :-

       

       

      GP < 25 %  Color Red

      GP <30 % >25% Organ color

      GP <30 % >35% Green color

      GP >35% Yellow

       

       

      May i know how to modify the script for above new condition ?

       

      I will post my QV sample in next posting.

       

      Paul