FormsByAir logo FormsByAir

The following functions can be used in formula expressions to aggregate data across repeated questions with the same tag.

Function Definition Example
any(<<tag>>) Boolean indicating if there is any occurence of a question with tag DEPRECATED: USE Any true
average(<<tag>>) The numeric average of question values with tag 10
join(<<tag>>) A comma separated string of all question values with tag DEPRECATED: USE ForEach 1,2,3
sum(<<tag>>) The numeric sum of question values with tag 100
unique(<<tag>>) Boolean indicating if all question values with tag are unique false

Sample Expressions

sum(<<Amount>>)

'join(<<Option>>)'

any(<<Warning>>) ? 'You have warnings' : ''