This capability allows the form builder to define a question whose answer is automatically calculated using a formula.
Note: The system also has a similar but different feature for managing form scores. Use score management for tests or evaluations where the form results in a single overall score.
How to Perform:
Create a new form or update an existing form.
Add at least one numeric base question (e.g., "What is the temperature of the chocolate?").
Then create a new question of type Info, and set the answer type to Formula.
Question Settings:
A formula question can be displayed or hidden.
It can be printed or not printed.
It is read-only and cannot be edited by the person filling out the form.
In the formula field, you can enter any standard formula that calculates between numbers, DATA KEYS, or Question IDs. Use square brackets
[DataKey]or[QuestionID]as needed.
Supported formula operators:
Addition:
+Subtraction:
-Multiplication:
*Division:
/Display maximum/minimum value from a list:
MIN,MAXDisplay average value from a list:
AVGUse of parentheses
( )
Limitations:
Currently, the system does not support the percentage symbol. To calculate percentages, divide the value by 100.
If the formula is not defined correctly, the system will display an error message (e.g., when a DATA KEY does not exist).
Formulas can only be defined outside of question groups at this stage. However, you can define a formula that aggregates values from within a group (e.g., the average age of all employees in the group).