mResult

Use mResult to perform calculations using a measure result. You can also use this function to:

Insert a previously collected result usingtimeOffset
Insert a result that will be collected using timeOffset
Perform operations, such as finding the average value of all the results a measure has collected
Perform a mathematical, statistical, and logical function on a measure result. See Inserting Functions.

To use mResult:

Select Application Data , thenMeasures, and double-click mResult.
Select the measure to use. To use the result of the current measure, select This Measure.
For example, this formula inserts the current result collected by the NetProfit measure:
mResult(“NetProfit”)
To use previously collected measure results, enter:
timeOffset(mResult(“measure name”),-interval))