topic Re: How to make it display red when -ve and Green when +ve ? in App Development

How to make it display red when -ve and Green when +ve ?

paulyeo11 — Tue, 29 Nov 2016 17:06:27 GMT

Hi All

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 ?

Paul

Re: How to make it display red when -ve and Green when +ve ?

paulyeo11 — Tue, 29 Nov 2016 17:08:08 GMT

qvf

Re: How to make it display red when -ve and Green when +ve ?

sunny_talwar — Tue, 29 Nov 2016 17:09:42 GMT

May be try with RGB()

If($(vSalesVariance) >0 , RGB(70, 198, 70), RGB(208, 25, 25))

Re: How to make it display red when -ve and Green when +ve ?

paulyeo11 — Tue, 29 Nov 2016 17:12:54 GMT

Hi Sunny

I have try , but the text color never change .

Paul

Re: How to make it display red when -ve and Green when +ve ?

sunny_talwar — Tue, 29 Nov 2016 17:13:58 GMT

It seems that you are using an extension? Is that true? I won't be of much help if that is true

Re: How to make it display red when -ve and Green when +ve ?

paulyeo11 — Tue, 29 Nov 2016 17:15:05 GMT

Hi Sunny

I am not using extension.

Paul

Re: How to make it display red when -ve and Green when +ve ?

sunny_talwar — Tue, 29 Nov 2016 17:16:00 GMT

Can you point out which object are you trying this on?

Re: How to make it display red when -ve and Green when +ve ?

paulyeo11 — Tue, 29 Nov 2016 17:19:43 GMT

Hi sunny

Re: How to make it display red when -ve and Green when +ve ?

sunny_talwar — Tue, 29 Nov 2016 17:22:36 GMT

Those button seems to be using extension because I am unable to view those buttons

Re: How to make it display red when -ve and Green when +ve ?

paulyeo11 — Tue, 29 Nov 2016 17:26:40 GMT

Hi Sunny

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 ?

Paul

Re: How to make it display red when -ve and Green when +ve ?

sunny_talwar — Tue, 29 Nov 2016 17:37:20 GMT

Added = in front of your variable definition. See if it is working now

Re: How to make it display red when -ve and Green when +ve ?

paulyeo11 — Tue, 29 Nov 2016 17:41:24 GMT

Hi Sunny

I just check , both -ve and +ve it display Red color.

Paul

Re: How to make it display red when -ve and Green when +ve ?

sunny_talwar — Tue, 29 Nov 2016 17:43:49 GMT

I am not sure what you button is doing. How did you get a positive value for the same expression?

Re: How to make it display red when -ve and Green when +ve ?

paulyeo11 — Tue, 29 Nov 2016 17:46:04 GMT

Hi Sunny

When SOURCE = TDSID , It will display +ve

When SOURCE = ADL , It will display -ve

Paul

Re: How to make it display red when -ve and Green when +ve ?

sunny_talwar — Tue, 29 Nov 2016 18:04:21 GMT

Check it out now

Re: How to make it display red when -ve and Green when +ve ?

paulyeo11 — Wed, 30 Nov 2016 00:55:55 GMT

Hi Sunny

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.

Paul