We are editing the paid dashboard by Chandoo. What we is the % change column to populate the actual value instead of it being based on if 'more is good' or 'more is bad'. Instead, the color circle should be the representation if more is good/bad.
IE; regardless if 'more is good' or 'more is bad' we want the % to show as 23% or -23%.
see snapshot below. In this case the 'Supply KPI' should read -2% in the top 5 KPI and -2.1 in the Apr-15 change. The color circle will be the indicator if its good or bad change.
Anyone know how to modify this to show it this way?
I appreciate any help!!
IE; regardless if 'more is good' or 'more is bad' we want the % to show as 23% or -23%.
see snapshot below. In this case the 'Supply KPI' should read -2% in the top 5 KPI and -2.1 in the Apr-15 change. The color circle will be the indicator if its good or bad change.

Anyone know how to modify this to show it this way?
I appreciate any help!!