% OF

% OF

Calculates the percentage value of a selected measure compared to a selected base group value.

Category

Math

Measure

Select a measure name from the list.

% Base

Select a base group from the list.

Returns

For the selected measure, Data Analyzer calculates the percentage of the base group total and displays the percentage value.

Example

For example, compare a cross tab revenue value to the grand total of all revenue values, using the following calculation:

(<cross tab revenue value>/<cross tab revenue grand total>) * 100%