9 Replies Latest reply: Sep 2, 2014 9:19 AM by saurabh kabra RSS

    Set color on basis of condition

      I am comparing data of two baseball teams and I want second team's data color on basis of data of first team

      Example If first team have win/loss ratio = 1.42 and second team have win/loss ratio 2.00 then second team's ratio must be in green color if it is greater than that of first and red if less than that of first.

      Here, both teams have different states(not the default one,i.e., inherited)

      Win/Loss Ratio for first team is calculated as-

      avg(aggr(avg({p7}Win_Loss_Ratio),TeamID))

       

      Please Help.

      Thanks in Advance.

      (Attaching Image for reference)