Formula Options

The Options tab in the Formula Properties dialog box allows you to further define how a formula will be computed. The following formula options are available:

·         Min: Specifies the minimum value returned by the formula.

·         Max: Specifies the maximum value returned by the formula.

·         Round: Specifies whether uneven calculation results should be rounded Up or Down.

·         Digits: Selects the number of digits for the Round option.

·         Hide zero values: Select this option to hide formula results that are a zero value. The field will not appear in the box if the returned value is zero.

·         Ignore Selected Group: By default, if a group is applied, boxes that are not included in the group are not included in the current calculation. The Ignore Selected Group option includes all boxes in a calculation regardless of the selected group. If you select this option, you can create a group based on a formula.

·         Exclude zero values: Select this option to exclude zero values from counts and products.

·         Exclude empty fields: Select this option to exclude empty fields from counts and products.

·         Assistants: Select whether the current formula includes assistants, excludes assistants, or includes only assistants. An assistant is defined as any box with the assistant branch style.

·         Duplicates: Specifies whether the current formula includes duplicate records (dotted line reports), excludes duplicate records, or allocates duplicate records. For example, if you select the allocation option, a person included in a chart three times has a value of 0.333 when one of the corresponding boxes is included in a count.