1 Reply Latest reply: Jan 9, 2013 5:13 AM by Klaus Kring RSS

    Set Analysis

    Srinivasa D

      Hi

       

      im trying to change font color of text object useing below set analysis.but its only working if i assign  value to some other variables then its working

      v1=MaxString(if(Id='05' and Type=$(vType) and Key='$(=$(vKey))' and num#('$(=$(vCalc))')*100 < High and num#('$(=$(vCalc))')*100 > Low,Color, 0))

      if i use v1 in text object calculated font color its working

      but i wold like to use directley as font color. how i can achive that as below

      =MaxString(if(Id='05' and Type=$(vType) and Key='$(=$(vKey))' and num#('$(=$(vCalc))')*100 < High and num#('$(=$(vCalc))')*100 > Low,Color, 0))

       

      Thanks

        • Re: Set Analysis

          Hi Srinivasa,

           

          so you aggregate over multiple lines and take the 'highest color'?

          What values are in the attribute color of your table, e.g. 'RGB(128,0,0)'?

           

          MaxString(RGB(128,0,0)) and =MaxString(RGB(128,0,0)) work in the definition field for Text and Background Color.

          Did you try without the = ?

           

          Greets

          Klaus