Maximum and Minimum format styles are now available in mTAB™. These new formats display the highest and lowest amounts of a ‘value’ question. Max and Min formats are especially useful when working with pricing analysis.

The Max and Min formats are accessible through the Format Styles Editor. For this example, a new format style will be created that includes Median, Max, and Min into one new format. Substitute Median for a different format if desired. Click the Format Styles Editor button, located to the right of the format drop-down box.

Click the ‘New’ button.

Give the new format a name. Click the [+] sign next to ‘Statistics.’ Select Maximum Value and/or Minimum Value. Double-click on the Max/Min formats, they will appear in the ‘Format Display Ordering’ box. Within the ‘Format Display Ordering’ box, rearrange the individual formats in any desired order, then click the OK button.

Depending on your account preferences, you may be prompted to save this new format as either ‘Private’ or to share it with other mTAB™ users who belong to the same user group as you do. If this message box does not appear, the new format will automatically save as a ‘Private’ format.

The New Format will appear in the ‘Available Styles’ box. Click the ‘Apply’ button.

The New Format Style should now appear as the format to be used in the format drop-down box. Click the lightning bolt to run the tab.

Note the newly created format with results displaying the maximum and minimum values.

New Format Styles – Maximum & Minimum