topic Re: KPI - Color Condition Formatting Based upon an expression not working in App Development

KPI - Color Condition Formatting Based upon an expression not working

jerryr125 — Tue, 07 Jan 2020 12:52:32 GMT

I have a KPI and I would like to have following set for the Color - Expression Formula:

=IF(SUM({<[IDate.autoCalendar.Year]={'$(vPriorYear2)'}>}IAmount) >= SUM({<[IDate.autoCalendar.Year]={'$(vPriorYear)'}>}IAmount),.75,.25)

If the Prior Year 2 IAmount is greater than the Prior Year IAMount, the color should be green, if not red.

The result is automatically defaulting to red, why ? thoughts ? Jerry

Re: KPI - Color Condition Formatting Based upon an expression not working

Kushal_Chawda — Tue, 07 Jan 2020 13:49:25 GMT

I think you can put single expression conditional color which compares the value with actual KPI expression automatically.

Let's say your KPI measure expression is below

SUM({<[IDate.autoCalendar.Year]={'$(vPriorYear2)'}>}IAmount)

Now in Appearance->Color->Add limit you can just put below expression. This will give you two different segment for which you can set two different color according to your requirement

SUM({<[IDate.autoCalendar.Year]={'$(vPriorYear)'}>}IAmount)