Calculation Settings

You can define the following settings for any numerical column in the structure browser. Labels display in the first column of the listing that is not a checkbox, a radio button, or an icon image. The label column spans the remaining columns up to the first column that contains a calculation.

Setting Description Values/Examples

Arithmetic Expression

Comma-separated list of arithmetic expressions. Expressions can include cell variables. See Arithmetic Calculations for details.

  

Calculate Average

When true, calculates the average of values in the column, using the defined decimal precision. By default, the calculation uses the system-wide precision (set in emxSystem.properties), or you can use the Decimal Precision setting to set a specific precision for this column calculation.

true

false (default)

Calculate Average Label

When the Calculate Average setting is used, any value for this setting shows as the label for the column average. If not defined, "Average" is used as the label.

Average (default)

<any string value>

Calculate Custom

When true, invokes the program defined by the Calculate Custom Program setting.

true

false (default)

Calculate Custom Label

When the Calculate Custom and Calculate Custom Program settings are used, any value for this setting shows as the label for that calculated value. If not defined, "Custom Label" is used as the label.

Custom Label (default)

<any string value>

Calculate Custom Program

If the Calculate Custom setting is true, this setting defines the program and function to invoke. The program can perform any calculations needed for the data in the column, with a single result.

program:function

Calculate Maximum

When true, displays the largest value of the column values.

true

false (default)

Calculate Maximum Label

When the Calculate Maximum setting is used, any value for this setting shows as the label for the column maximum. If not defined, "Maximum" is used as the label.

Maximum (default)

<any string value>

Calculate Median

When true, displays the middle value (the mean) of the column values. If the column contains in an even number of values, the average of the 2 middle numbers is used, using the defined Decimal Precision. By default, the calculation uses the system-wide precision (set in emxSystem.properties), or you can use the Decimal Precision setting to set a specific precision for this column calculation.

true

false (default)

Calculate Median Label

When the Calculate Median setting is used, any value for this setting shows as the label for the column median. If not defined, "Median" is used as the label.

Median (default)

<any string value>

Calculate Minimum

When true, displays the smallest value of the column values.

true

false (default)

Calculate Minimum Label

When the Calculate Minimum setting is used, any value for this setting shows as the label for the column minimum. If not defined, "Minimum" is used as the label.

Minimum (default)

<any string value>

Calculate Standard Deviation

When true, displays the standard deviation of the column values using this formula:



where:

N=total number of elements

xbar=mean of the column values

By default, the calculation uses the system-wide decimal precision (set in emxSystem.properties), or you can use the Decimal Precision setting to set a specific precision for this column calculation.

true

false (default)

Calculate Standard Deviation Label

When the Calculate Standard Deviation setting is used, any value for this setting shows as the label for the column calculated value. If not defined, "Standard Deviation" is used as the label.

Standard Deviation (default)

<any string value>

Calculate Sum

When true, displays the total of the column's values.

true

false (default)

Calculate Sum Label

When the Calculate Sum setting is used, any value for this setting shows as the label for the column sum. If not defined, "Total" is used as the label.

Total (default)

<any string value>

Decimal Precision

Defines the decimal precision for all calculations for this column. The system properties setting emxFramework.SBTableCalculations.DecimalPrecision defines the system-wide value; this setting overrides that value. You only need to use this setting if you want to use a value other than the system-wide value (defined in emxSystem.properties).

Any positive integer.