Red color for negative numbers in Analysis Services 2005

Sometimes there is a simple way to solve an issue. For example, if you want to color all measures (including calculated measures) in red when the value is negative, you can simply write:

SCOPE( Measures.AllMembers );     FORE_COLOR(THIS) = IIF( Measures.CurrentMember < 0, 255, 0);  // 255 = RED END SCOPE;

 

MDX Script is so better than classical properties for each measure in these cases…