UsemComparator to perform calculations as follows: .
Using a target other than that selected from the Report Target list, that you specify by name. For example, if you have targets for financial quarters called Q1, Q2, Q3, and Q4, and Q2 is the Report Target, use mComparator to insert values for Q1 or Q4 in a formula. If the target you select is multivalue, the subtarget highest in the order is used.
Using a target and a corresponding subtarget that you specify by name, regardless of the order of the subtarget. For example, you could insert the value for the Minimum subtarget although it is last in the defined order.
As such, mComparator essentially enables you to perform calculations using a particular target regardless of the selected Report Target or, for multivalue targets, the order of a subtarget..
To use mComparator:
Select Application Data, thenMeasures, and double-click mComparator.
Select the measure to use. To use the current measure, select This Measure.
Select the target to use from the Select Target box that is displayed.
Insert the functions and calculations to perform.
For example, to insert the value for a target called ShortTerm, you would use this formula: