two KPI objects, one for 2009 payroll, another for 2010 payroll. in the second object i want to show numbers colored based on if payroll has increased, decreased or stayed the same with colors as red(increased), green(decreased), yellow(no change). Can't get the colors to show correctly!
i am using the expression as a max number so it is dynamic. =Sum({$<Year={2009}>}Pay)