first expression should get blue and second expression some other colors.
I have written some expression here. but, for both the bars I am getting same color.
Can any one suggest me on this problem?
if(NumOfFailures=0,
if((Sum({<CalendarMonth={'$(vMaxMonthYear)'},EquipmentCategory ={'Locomotive'}>}AssetMiles)
/
Sum({<CalendarMonth={'$(vPrevMonthYear)'},EquipmentCategory ={'Locomotive'}>}NumOfFailures))>0,
RGB(35, 164, 145),
if((Sum({<CalendarMonth={'$(vMaxMonthYear)'},EquipmentCategory ={'Locomotive'}>}AssetMiles)
/
Sum({<CalendarMonth={'$(vMaxMonthYear)'},EquipmentCategory ={'Locomotive'}>}NumOfFailures))>0,
RGB(35, 164, 145),
RGB(35, 164, 145)
)
)
,
if((Sum({<CalendarMonth={'$(vPrevMonthYear)'},EquipmentCategory ={'Locomotive'}>}AssetMiles)
/
Sum({<CalendarMonth={'$(vPrevofPrevMonth)'},EquipmentCategory ={'Locomotive'}>}NumOfFailures))>0,
RGB(14, 49, 146),
if((Sum({<CalendarMonth={'$(vPrevMonthYear)'},EquipmentCategory ={'Locomotive'}>}AssetMiles)
/
Sum({<CalendarMonth={'$(vPrevMonthYear)'},EquipmentCategory ={'Locomotive'}>}NumOfFailures))>0,
RGB(14, 49, 146),
RGB(14, 49, 146)
))
)
