Formulas MD3
search

Apply Formula MD3

anchor links?

Formula as Inference Method of a Variable

Most variables have the inference method 'Ask user'. When inferenced in a consultation, the user must enter a valid value. Variables are also 'deduced'. The combination of preceeding answers leads to a value.

The variable value can also come from execution of a formula when the variable is inferred. The variable must be domain type Number List or Number Length. The actual arguments must be numerical: a literal number or another variable of domain type Number List or Number Length.

Also with the correct domain type we must ensure that possible calculation results 'fit' in the domain. So please check the settings Whole/Decimal, number of decimals, and Interval.

Creation and management of the inference method.

Formula in the action of a table

Have a formula created. Open a table. Make the condition part complete and correct. Do the next:

  1. In an action subject insert a Number Length variable. (It can be a Number List variable but then be sure that the formula result is in the domain.)
  2. In an action value at the right type the formula name followed by an open-parenthesis (
  3. Type behind it correct actual arguments, separated by commas:
    • literal number
    • variable reference with keyword: VALUE(variablename)
  4. Be sure to specify the right number of arguments and close with close-parenthesis )

The formula call can be applied in more action values. As it requires exact typing, copy and paste could help. Thus the variable is assigned and can participate in further consultation.