=========
QUESTION
———
I want to calculate my own Metrics based on metrics already in my report – similar to what you do with a formula in Excel, or a calculated field or Expression in Microsoft Access.
=========
ANSWER
———
This is called a Derived Metric in MSTR terminology.
To create this Derived Metric, inside the Report Editor in Design View, right-click an existing Object under Report Objects, or a Column Header under Report View, and select Insert, New Metric…
Then build your new expression using the listed report objects on the left and the buttons above the expression field for your math.
Click the validate button before clicking OK just to double-check things before you save.
=========
EXAMPLES
———
see ANSWER
=========
APPLIES TO / KEY WORDS
———
MicroStrategy
Derived Metrics
Calculations
Calculated field
=========
REF
———
—
http://www.anysitesupport.com/mstr-derived-metrics/
http://anySiteHosting.com