I was wondering what the best way is to flip the sign of a measure's FormatString (not the value).
I need to flip the sign of my measures for display purposes only for certain scenarios (for example for the scenario Actual vs Plan). The calculation of the roll-up must take place using the "normal" unflipped sign.
I was thinking to do it in a similar way than the following currency flipping example
CREATE MEMBER CURRENTCUBE.[MEASURES].[Currency Test]
AS [Measures].[Fact Value],
FORMAT_STRING = “Currency”,
VISIBLE = 1 ;
Is there a better way to do it. Many thanks in advance
View Complete Post