MicroStrategy ONE
Derived element effects on derived metrics
Most derived metrics are represented correctly by derived elements. However, note the following:
- In reports, a derived metric that uses division, such as
Profit/Revenue
, is initially calculated incorrectly when using derived elements. This is because, by default, derived metrics are evaluated before derived elements. You must change the evaluation order to evaluate derived elements before this type of derived metric. For information on derived element effects on derived metrics and how to evaluate them correctly, see Derived element interactions with derived metrics. - In Report Services documents that use multiple datasets, if you create a derived metric that uses metrics from two or more datasets, the derived metric may display unexpected results for derived elements on Grid/Graphs. To ensure that such derived metrics are evaluated correctly, you must change the evaluation order to evaluate derived elements before this type of derived metric. For information see Derived element interactions with derived metrics.