MEDIAN

Use MEDIAN to insert the value would be in the middle of a group of values. For example, the median of these values is 80 which is the average of the two center values (70 and 90):

This function uses the following syntax. Arg1... represents the function that retrieves the kind of values to use and the object whose values to use:

MEDIAN(arg1, arg2...)

  To use this function:

  1. Select Functions , then Statistical , and double-click MEDIAN.

    This inserts MEDIAN(arg1, arg2...)

  2. Delete arg1 and insert the function that retrieves the values to use.

    For example, to find the highest target defined for a measure, insert mTarget.

  3. Select the object to use from the box that is displayed.

  4. Repeat steps 2 and 3 to specify the remaining arguments.