I want to make the text color display red when the value is -ve and green color when +ve.
I have place the below expression at condition color :-
if($(vSalesVariance) >0 ,'#46C646','#d01919')
But the color does not change. Hope some one can advise me where i go wrong ?
May be try with RGB()
If($(vSalesVariance) >0 , RGB(70, 198, 70), RGB(208, 25, 25))
I have try , but the text color never change .
It seems that you are using an extension? Is that true? I won't be of much help if that is true
I am not using extension.
Can you point out which object are you trying this on?
Those button seems to be using extension because I am unable to view those buttons
Yes i use extension , that is 2 button for select field value . to make the value display +ve and -ve.
By the why , Can you make the 15.3 change from black to Green ?
Added = in front of your variable definition. See if it is working now
I just check , both -ve and +ve it display Red color.
I am not sure what you button is doing. How did you get a positive value for the same expression?
When SOURCE = TDSID , It will display +ve
When SOURCE = ADL , It will display -ve
Check it out now
Many thank , now all my KPI work fine.
Now the expression is more simplify. But need to adjust the color bar in order to make it. Also after paste the expression into the box , it turn to become number. Don't ready understand but it work.
Retrieving data ...