Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi the community,
I try to design a KPI in text box.
I would like to color a percent value (red if <0 and green if >0).
I have this expression :
=num(
((sum( {<Mois = {$(=Max (Mois))}>}Visites))-(sum( {<Mois = {$(=num(Max (Mois)-1,'00'))}>}Visites)))
/sum( {<Mois = {$(=num(Max (Mois)-1,'00'))}>}Visites)
,'+##0,0%'
)
it gives me :
Anybody could tell me how to manage to color the value ?
Thank you,
go to font tab or Text Box Properties
and Select Color and use Conditional color !
Hi Manish,
Thank you. I tried this and it does not work :
if(
(
num(
((sum( {<Mois = {$(=Max (Mois))}>}Visites))-(sum( {<Mois = {$(=num(Max (Mois)-1,'00'))}>}Visites)))
/sum( {<Mois = {$(=num(Max (Mois)-1,'00'))}>}Visites)
,'+##0,0%'
) > 0, rgb(255,0,0),rgb(0,128,0))
)
An idea ?
Provide your sample file..