Production > Variant production > Variant generator > Formulas - robinfeng/beashelp GitHub Wiki

• 数据窗语法

Navigation: Production > Variant production > Variant generator: Formulas No contents entries on this page Contents All types of formulas are managed here, e.g.:

• Planned time calculation formulas
• Bonus calculation formulas
• Output calculation formulas

The formula number enables assignment of a formula to time components, operations, BOM positions, or bonus components, thus facilitating the calculation of:

• Default times
• Material requirements
• Bonus results
• Other technical data

The result calculated from a formula can also be allocated to a variable.

A formula consists of:

• Formula flag: Unique flag used to identify the calculation (e.g. F4711)
• Description: Describes the function or the use of the formula (comment)
• Formula string: Any mathematic and logical formula can be entered here. All numbers and characters are permitted.

If a formula is selected or created new, a new window opens:

Formula tab Field Description Formula Formula name Match code Match code Description Formula description Formula String Definition of formula Type Output of formula (numeric or string) Dec Number of decimals (for numeric type)

Variables tab (Definition variables of used in formula) Field Description Variable Variable name Description Description of variables Type Output of formula (numeric or string) UoM Unit of measurement Origin type Origin of variable:

• Formula
• Table
• Variant (from product configuration)
• Item field
• Order line
• Manually (enter manually at run time)
• beas-Script Origin name Object name from origin type Change Allow changes at run time Validity Validity of variable:
• local (only within the formula and all formulas and tables called by it)
• shared (within the assembly and for all following items, but not sub-assemblies)
• global (in complete structure from the moment of calculation) Operation Mark, to save the variable globally with prefix "agbez_". Then it can be accessed in a description of an operation. see Operation Variables Cross reference Enter a link (Only useful with origin type "manually" or "Change") Sorting Order of processing variables

Formula string The following must be observed when using variable designations:

• Maximum length of 20 characters
• No blank spaces or mathematical symbols may be used (+ - period, comma etc.)
• Variable names may not consist of reserved names (function names).
• Variables must begin with a letter
• Umlauts and ß may not be used.
• Unlike in the product configurator, variables do not have to be delimited by [ .. ].
• Formel syntax corresponds the Syntax of Datawindow (R) - Interpreter of Sybase (R)
• The number of variables is not limited

The syntax is the same as the DataWindow syntax. see: Datawindow-Syntax