KPI - Color Condition Formatting Based upon an expression not working

[jerryr125]

Hi 

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

[Kushal_Chawda · Accepted solution]

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)