gotcha - in that case, give this one a shot... scope to the leaf level below the [Income Statement] member and let the engine handle the aggregation back up through the levels between.
SCOPE(
DESCENDANTS (
[Dim FMS Heirarchy].[FMS Reporting Hierarchy].[FMSH Financial Page].&[Income Statement],
,
LEAVES
)
);
This = [Measures].[FMSA Monthly Activity] * (-1);
Fore_Color ( This ) = "255";
END SCOPE;
Data Enthusiast | @SQLbyoBI | www.opifexsolutions.com