Use this calculation type on a master form to create a definition result by multiplying or dividing two quantities. For example, Average Unit Cost: Total Unit Cost / Number of Units.
Configuration
These are the basic steps to configure this calculation type. Formever will lead you through as you point and click.
- Label the definition
- Select the first field
- Select the operator
- Select the second field
- Specify result attributes
Step 1 - Label Definition
Give the definition a descriptive label. This doesn’t have to be done first. But make sure you provide a descriptive label before filing the master form. Since definitions are used throughout the system a descriptive label is recommended.
Doing it first serves as a reminder of what you are trying to accomplish as you configure the definition.
Step 2 - Select the First Field
Select the first field or definition to include in the calculation. Click on the ‘Select field’ text and the field chooser will open.
Step 3 - Select the Operation to perform
Click on the blue text beside the "Operation:" label to toggle between ‘Multiple by’ or ‘Divide by’ operators. The default operator is ‘Multiple by’.
Step 4 - Select the Second Field
Select the second field or definition to include in the calculation. Click on the ‘Select field’ text and the field chooser will open.
Step 5 - Specify Result Attributes
Below the fields in the calculation are various result attributes that can be specified. Result attributes are those used if the result is displayed in its default format. The default attributes are shown in the image above. The resulting display format is shown at the very bottom of the definition.
Modify Results: Indicate if the result value or result sign should be modified. The most frequent use for these is in financial reports.
Result modification choices:
- Leave as calculated
- Force to zero if negative
- Force to zero if positive
- Force to positive
- Force to negative
- Reverse sign
Number of Digits before decimal point: Set the number of digits to allow in the field before the decimal point. Adjust by clicking the green portion of each digit to increase and the red portion to decrease.
Number of Digits after decimal point: Set the number of digits to allow in the field after the decimal point. Adjust by clicking the green portion of each digit to increase and the red portion to decrease.
Sign Type: Click to select the sign type for the result. Sign type is only used to display the sign – it does not affect the sign of the actual quantity.
Sign type choices:
- None
- Minus Sign
- Cr/Db with zero being a Credit
- Db/Cr with zero being a Debit
- Parentheses ()
Unit Position: Indicate where the unit symbol should be positioned when the result quantity is displayed.
- Unit behind amount
- Unit in front (fixed position far left ) of amount
- No unit sign
Result Unit: Indicates the unit type of the result quantity when it is displayed. The default result unit is based upon the fields used in the calculation. Depending on the result unit it can be changed to other related units. For example, if the default result unit is hours, this can be changed to minutes, seconds, days etc.