Webi will combine like values unless specifically told not to. For example: You want to find the average numeric answer for a TouchPoint question. The participant's answers are: 5, 5, 5, 5, 1

The actual average is 4, but if you put these answers into a table with the [Response ID] field and asked for an average, Webi would return 2.5. Webi does this because it sees all of the "5" answers as a single answer. Without the proper context, it is averaging 5 and 1. To fix this, context needs to be applied to the average formula as in the formula below.

= Average([TP Answer] in ([Response ID))

Or you can create your own Average calculation with a solid numerator and denominator:

= Sum([Question_123]) / Count ([Question_123];All)

This context specifically tells Webi to average the results of all answers with a different [Response ID] individually, even if some of the results are the same.

For more information on aggregate formulas see: ETO Results: Incorrect Totals/Aggregates.

Did this answer your question?