Creating a logical formula field
- Specify the virtual field ID using the naming convention, &XXXX. Use option 1='Create'.
- Specify the column heading by either specifying a description or a message ID. If specifying a description, you can defined the column heading per language by pressing the language button. If specifying a message ID, the column heading is automatically displayed in the end user's M3 language.
- Select virtual field type 6-'Logical formula'.
- Specify the logical type for the condition, alphanumeric or numeric.
- Specify the first operand which is a field from the field group.
- Specify the condition.
- Specify how to set the second operand which are field from field group, specific value, or blank.
- Specify how to combine two or three different conditions.
- Specify how to set the value if condition is true which are field from field group, specific value, or blank.
- Specify how to set the value if condition is false which are field from field group, specific value, or blank.
- Press Enter.