Creating a calculated field

  1. Specify the virtual field ID using the naming convention, &XXXX. Select option 1='Create'.
  2. Specify the column heading by specifying either a description or a message ID. If specifying a description, you can defined the column heading per language by clicking the language button. If specifying a message ID, the column heading is automatically displayed in the user's M3 language.
  3. Select virtual field type 1='Calculation'.
  4. Specify the calculation sequence. The field is used if other virtual fields are used as objects in the calculation formula. The current virtual field must have a higher calculation sequence then the virtual fields used as objects in the calculation formula.
  5. Specify the number of decimal places, either by specifying Number of decimal places 0 – 4, or selecting a field information code.
  6. Specify the calculation formula by specifying Operator (+, -, /, *), Object (field from main table, related table, custom subtotal fields, or other virtual field) and factor.
  7. Press Enter.
Related topics