Defining Formulas 

Procedure

  1. Double click on the cell in the quantity column of the template in which you want to define a formula. This action takes you to the activity quantity formula editor.
  2. Enter a formula. Enter values directly or activate button Function and choose a function from the function tree.
  3. The type of function you chose will determine how you should proceed (the function type is not clear at the time you choose the function).

Chosen Function or Entry

Further Steps

Enter the value directly or you have chosen a Function without parameters.

Proceed with step 4.

You chose a function that is assigned to a table. You can tell that this is the case if screen Definition of a flexible function appears.

Define a flexible function (see Defining Flexible Functions and Implementing the Function).

After the definition, continue with step 4.

You chose a Function with parameters. An additional screen will appear.

The lines indicate the parameter type "normal" or "optional" (see the note in the right column and Function Parameters, section "Parameter Type and Default Value").

Enter a value for each row for which you choose F4, and then choose Fixed value or Functions/Variables. The values or functions available for selection are determined during the function definition in tab Function Use .

  • If you select Fixed value, you can enter the value directly or you get a selection window where you can select specific master data.
  • If you choose Functions/Variables, choose a function from the function tree.

You must enter something in the empty cells of column Value (parameter type "normal"). You can enter something (parameter type "optional") in cells with apostrophes.

  1. To check if your entries can be properly processes, choose button Check or Formula ® Check.
  2. To format an entered formula, choose Formula ® Format.
  3. To get information for a chosen function, position the cursor on the function name and use the button Information about Function or choose Formula ® Information about function.
  4. To leave the editor, choose Back (your entries remain until you save the template).

For more information on the Editor, see Processing Possibilities in the Editor.