topic Re: KPI Chart - display a number which is negative in red in App Development

KPI Chart - display a number which is negative in red

jerryr125 — Mon, 22 Apr 2019 20:19:05 GMT

Hi -

I have the following KPI :

Sum((ProductMonthlyTotalQuantitySold)-(ProductMonthlyForecastQuantity))

work perfect !

1. How do I display the KPI in red if the difference is less than 0 ?

2. How do I display the negative number in () ?

Thanks - Jerryr

Re: KPI Chart - display a number which is negative in red

dplr-rn — Mon, 22 Apr 2019 20:34:07 GMT

Answer to 1 - KPI-->Colors--> Set conditional colors on. turn library colors off set limits on colors etc. (you can do this in master measure as well)
Answer to 2 - format number as custom use a format similar to #,##0.00;(#,##0.00)

Re: KPI Chart - display a number which is negative in red

jerryr125 — Mon, 22 Apr 2019 21:06:41 GMT

thank you - perfect!!!

Re: KPI Chart - display a number which is negative in red

dplr-rn — Mon, 22 Apr 2019 21:10:21 GMT

No problems