Set Analysis

[srinivasa1]

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

[#2]

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