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.
· 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.