0 Replies Latest reply: Sep 22, 2017 1:54 AM by V Kumar RSS

    How to apply colors in single and Multiple values

    V Kumar

      Hi All,

       

      I have a requirement. in my source file i have diff columns like below

      SITE LIMIT 1 CONDITION

      SITE LIMIT 1 VALUE

      AGGR LIMIT 1 CONDITION

      AGGR LIMIT 1 VALUE

      here i have concatenated site and Agg value and condition

       

      "SITE LIMIT 1 CONDITION" & "SITE LIMIT 1 VALUE" as Site_Red,

      "AGGR LIMIT 1 CONDITION" & "AGGR LIMIT 1 VALUE" as Agg_Red,

      but my actual req is i have below data

        

      IDCodeSITE LIMIT 1 CONDITIONSITE LIMIT 1 VALUEAGGR LIMIT 1 CONDITIONAGGR LIMIT 1 VALUE
      5013W1>0>0
      5009W2>50<0.8
      5016W3>10<0.8
      5015W4>95<0.8
      5013W1<10>5
      5013W1>=10>15
      5009W2>0<0.8

       

      here i want to display Color based on ID here i want to display color as Red for Site_Red  & Agg_Red columns.

      if it is single value it should display site_red if is multiple values it should display Agg_red based on ID.

       

      Pls help on this

      stalwar1

      reddys310

       

      Thnaks in Advance.