Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
Anyone?
Hi
sorry, but i'm not following at all....
Some questions:
Rgds
Thank you for your reply:
Thnks...
or maybe put the numbers with color. The idea is change the color of the numbers or inside of the text object.
Anyone?
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.