Calculations have been added to the Assessment Builder. They allow you to:
- calculate values for reporting, for example; you may wish to calculate the return on Investment based on data collected in the assessment or
- to calculate a score based on previous input, for example, you may want to calculate a score based on a number entered into the assessment. A score calculated in this way will be added to subsection, section, assessment, and potentially a segmentation score as if it was a standard question and answer.
- both values and scores can use response answers, scores at all levels, and literals as input to the calculation.
Calculations can occur anywhere in an assessment but are hidden in the response. The results can appear in subsequent sections, however, as text in a question or instructions, using question piping; or they can be used to drive conditional questions. The system treats them as a question and an answer so all of the feedback reporting options work with calculations - either as a calculated value or a score.
Calculations use the power of Microsoft's Transact-SQL, meaning that as well as regular operators like +-*/ with or without brackets, advanced users can access the Mathematical and String functions that Transact-SQL offers for a single field. They can also use expressions like Case statements for logic. Database statements are not allowed for security reasons.
For further information, see Calculations
Section and Subsection Conditions
You can now make sections and subsections conditional in the same way as you could previously make a question conditional on previous answers. Like questions, they can be conditional on up to 5 "and" answers and an unlimited number of "or" answers. When a section is conditional the system skips over it completely.
A typical use case for this functionality is scenarios where different sections of an assessment apply to different roles.
Both Section and Subsection dialogue boxes have an extra "Advanced" tab added where the conditions can be specified.