Insert Microsoft Excel calculations

You can insert any Microsoft Excel calculation, such as AVG, MIN, or MAX into an Exploration View or list. You can reference cells both inside and outside the exploration.

Procedure

  1. Insert a blank column or row.
  2. Create the calculation in the first cell that applies to the inserted column or row.

    You must create the formula for the calculation in the cell closest to cell A1 (the upper left most cell) of the inserted group.

  3. After you have created the calculation for a single cell, from the toolbar, click Use Server formats to remove custom formatting.

Results

The calculation is propagated to all the inserted cells.
Tip: You can apply conditional formatting to the calculated column or row. Select the column or row. Click Home and then click Conditional formatting. Use the conditional formatting menu to choose the styles for the cells.