RE:Exact colur

[Chanty4u]

Hi all,

I have some issue on colur coding.  below is my code for  colurs

  count(if(Prod_Severity = '1-Critical' or Prod_Severity = '2-Major',Prod_Defect_ID))

  ) * 100 < 95, rgb(255,0,0),

but am getting   for  100%   its shwng  amber  without any selections.

and if i do any selection that value is 100%  and colur shwng as green?

how come  is there any issue in the exp?

Thanks in advance.

[Chanty4u]

sudhakar,

its givng error aftr  ","   comma

[brijesh1991]

If(

Count({$<Prod_Severity = {'1-Critical', '2-Major'}>} Prod_Defect_ID) < 0.95, RGB(255,0,0),

if(

(Count({$<Prod_Severity = {'1-Critical', '2-Major'}>} Prod_Defect_ID)  >= 0.95

and

Count({$<Prod_Severity = {'1-Critical', '2-Major'}>} Prod_Defect_ID)  < 1), RGB(255,200,10), Green())))

Please add/ remove any brackets I missed here!! Writting directly here.

[Chanty4u]

No luck

[sunny_talwar]

Would you be able to provide a sample?

[Chanty4u]

hi sunny,

i hve edited my thread with  complete expression which is used in text object.

in font tab  i hve given abve expression.