- Select the Work with configurator formulas menu item.
- On the initial panel, click Add to add a new formula.
- You access Configurator formula maintenance. Complete the following fields:
- Formula code
- Enter a code that identifies the formula.
- Description
- Enter a description of the formula, such as calculated price, sales price or weight calculation.
- Formula
- Enter the method of calculation. The formula can contain any or all of the following:
- Active system defined variables. Available variables are displayed in the Variables field.
- Numeric attribute codes. A percentage sign (%) must be added as a prefix to the code.
- Numeric constants (0-9). A decimal sign (,) may be used.
- Arithmetic operators: +,-,*,/
- System defined functions
- SEARCH(“User defined table”). Searches and returns a value from the specified user defined table. The table defines the search argument (keys) and the search method to be used.
- ROUNDD(“No of dec”). Rounds down the “current” calculated value of the formula to the specified number of decimal digits (0-3).
- ROUNDU(“No of dec”). Rounds up the “current” calculated value of the formula to the specified number of decimal digits (0-3).
- Parentheses. A maximum of 10 parentheses may be used.
- Calculation program
- Enter a user defined calculation program instead of a formula.
- Note: The possibility to refer to a user defined calculation program is foreseen as an exit program. This can be used to handle complex calculations and to look up information in user defined tables without changing the core application. The user defined program must have the parameter list as defined in the core calculation program, CFG042C.
- Number of decimals
- Enter the number of decimals for the calculated value using this formula. The range of decimals can be from 0 to 3.
Tip: If you use the user defined table FACTA1 to define a factor for different values of the attribute A1, you could define the formula for calculating the component quantity that is dependent on attribute A1 as:
| &01 * SEARCH(FACTA1) ROUNDU(2) * &04 |
Note: You must enter either a formula or a calculation program.
Refer to the Panel help for detailed information about the remaining fields.
Click OK when you have completed all relevant fields. The system updates the new formula and clears the panel. Return to the initial panel to view the formulas listed in alphabetical order according to the formula code. Exit the routine.