After creating an analysisAn analysis is a table/chart created by dragging variables from the project tree into the analysis zone of Harmoni , you have the option to interact with the settings and change as needed to suit your specific reporting requirements. You can do this using the options available in the modify menu.
The options under format allow changing the values displayed in your analysis. Any row or column in an analysis can display different values including counts (weighted or unweighted), percentages, averages, etc.
The modify menu is available to Creators and Explorers. Viewers can also interact with these features when they have access to dashboards, or stories, where the analysis can be zoomed.
In this article:
 Add/Replace switch
 Analysis value options (count, percentages, bases, averages, etc.)
 Display settings adjustment
 Rounding in Harmoni
1. Add/Replace Switch
The add/replace switch allows creating tables that show either complimentary data displays or singular displays. This can be applied to a selected part of the table/chart or the whole table/chart.
a) Replace
While the add/replace switch is on replace any data calculation change will replace the currently selected item (or the entire table if nothing is selected).
b) Add
If the switch is moved to add:
 Any new data type/calculation selected will be added as a new column or row next to the item you have selected.
 If nothing is selected, the default will be to create a new column of the data display for each of the original columns of that table.
2. Analysis value options
Icon  Option  Description  
Standard Axes 
Measures  Options  
Weighted count 
Weighted count of data records for an element. If there are no weights this is the same as the unweighted count (u123). 
Weighted count of data records with a value. 
Decimal Options 

Unweighted count 
Unweighted count of data records for an element. 
Unweighted count of data records with a value. 


Percentage 
Weighted count divided by the weighted Base.

Weighted count of data records with a value in the measure divided by the count of data records included in all measures in the dimension. 
Decimal Options 

Unweighted base 
Unweighted count of data records in Base. 
Unweighted count of data records included in any measure in the dimension.
Unweighted sigma base doesn't have an icon in the modify menu. It will show when the analysis includes a measure. In an analysis with a measure or average, add mode will ad the uB, and replace mode will replace with . 
Decimal Options 

BaseLearn more about Analysis Bases. 
Weighted count of data records in Base. If there are no weights this is the same as the unweighted base (uB). 
Weighted count of data records included in any measure in the dimension.
Sigma base doesn't have an icon in the modify menu. It will show when the analysis includes a measure. In an analysis with a measure or average, add mode will ad the B, and replace mode will replace with .

Decimal Options 

Differences 
Difference between an element and the reference. 
Difference between the measure and the reference. 
Decimal Options Format Options 

Indices 
Proportional difference between an element and the reference. 
Proportional difference between a measure and the reference. 
Decimal Options 

Available when showing a measure 

Averages 
Standard Axes with values Summ of values divided by the count of data records with value. 
Summ of values divided by the count of data records with value. 
Decimal Options 

Sum Value Percentage 

Weighted sum divided by the sum of values across all measures in the dimension. 
Decimal Options 

Sum Value 

The weighted sum of values in the measure. Sum of values across all respondents in the cell. 
Decimal Options 

Unweighted Sum Value 
The unweighted sum of values in the measure. 

3. Display settings adjustment
a) Decimal Options
You can select the number of decimals to display using the decimal options.
 Icons that display an arrow at the bottom, allow expanding.
 Up to four decimal places can be selected for values that have this option.
 Decimal places are set independently for each value type.
b) Base Options
There are different base options available in Harmoni.Cell Base
This is the default selection, as typically the desire is for bases in the analysis to be cellbased.
 Each column has a different base for columnbased percentages.
 Each row has a different base for rowbased percentages.
Total Base
Percentages and/or averages are calculated by dividing the counts for an individual cell by the table total (usually on the topleft cell of the table).
Total Base (Totals Only)
This option allows for the Total row to have a different directional base to the rest of the table.
Apply Total Filter to Base
For analysis containing an applied base.
c) Format Options
4. Rounding in Harmoni
Harmoni applies Bankers rounding.
Bankers Rounding is an algorithm for rounding quantities to integers, in which numbers that are equidistant from the two nearest integers are rounded to the nearest even integer.
We round 0.5 to the nearest even digit.
Example:
 7.5 rounds up to 8 (because 8 is an even number)
 but 6.5 rounds down to 6 (because 6 is an even number)
Bankers rounding is unbiased. Over the course of many roundings, all the .5's will round equally up and down. This gives a better estimation of actual unrounded results. For example, the sum of the rounded values will be close to the sum of the unrounded values.
Other common rounding methods such as roundingup in Excel will, over a large number of rounded values, bias away from the unrounded total.
Bankers rounding (or Round halftoeven) is the default rounding mode used in IEEE 754 computing functions and operators.
Rounding on Export
 When exporting to Excel, Harmoni exports numbers with the same number of decimal points as shown in Harmoni.
 When exporting to PowerPoint graphs, Harmoni plots the full number, but display the rounded number.
 For example, in a graph, we plotting 2.61 and 2.65, so the 2.61 appears lower, but they both show 2.6.
 When exporting to PowerPoint tables, Harmoni exports numbers with the same number of decimal points as shown in Harmoni.