Indicators Formatting

[pgalvezt]

Hi everyone, I've created a text object with this formula, but it doesn't work. The idea is, when the indicators is greater than cero = green, if not red. Thanks for your help.

=

if(count({<Aprovador_Remessa={'Célula de Ativo Fixo'},Emergencial_Remessa={'1 Hora'},AprovadorNivelRemessa={'Célula de Ativo Fixo-20'},[Processo Dias]={'Até 1 Hora'},Status_Remessa={'APR'}>}Aprovador_Remessa))/Count({<Aprovador_Remessa={'Célula de Ativo Fixo'},Emergencial_Remessa={'1 Hora'},AprovadorNivelRemessa={'Célula de Ativo Fixo-20'},Status_Remessa={'APR'}>}Aprovador_Remessa > 0.99, RGB(255 ,0, 0),RGB(0 ,128, 0))

[pgalvezt]

Anyone?

[hector]

Hi

sorry, but i'm not following at all....

Some questions:

• Is this the expression on a chart with type Indicator?
• or is this the expression of a text object and you want to change the bkg color??

Rgds

[pgalvezt]

Thank you for your reply:

• this is the expression of a text object and upper 0.99 I want to put in yellow, lower in red, and 100% in green.

Thnks...

[pgalvezt]

or maybe put the numbers with color. The idea is change the color of the numbers or inside of the text object.

[pgalvezt]

Anyone?

[#7]

Shouldn't there be a ")" here:

Aprovador_Remessa) > 0.99

Otherwise the second Count() expression doesnt end until the first ")" is encountered.

So

=

if(count({<Aprovador_Remessa={'Célula de Ativo Fixo'},Emergencial_Remessa={'1 Hora'},AprovadorNivelRemessa={'Célula de Ativo Fixo-20'},[Processo Dias]={'Até 1 Hora'},Status_Remessa={'APR'}>}Aprovador_Remessa))/Count({<Aprovador_Remessa={'Célula de Ativo Fixo'},Emergencial_Remessa={'1 Hora'},AprovadorNivelRemessa={'Célula de Ativo Fixo-20'},Status_Remessa={'APR'}>}Aprovador_Remessa) > 0.99, RGB(255 ,0, 0),RGB(0 ,128, 0))

If this is the expression in the text box, then the answer here iseither RGB(255 ,0, 0) or RGB(0 ,128, 0). So not the colour, but that text.

To use this, you need to past the expression in the Font tab under the Color button and then in the Calculated Base color field.