Infiniti provides several functions for certain tasks which are grouped under two categories – Formula Functions and Aggregate Functions.
To perform more complex calculations, formulas may also incorporate various math, date and text functions. For example, the DateDiff() function can be used to calculate a person’s age based on their date of birth and today’s date.
Functions require a set of parameters to determine a result. These parameters may be literal values, references to other questions, or even other functions. Functions must include the function name followed by any parameters in brackets, or empty brackets if no parameters are required. Parameters are separated by commas.
A collection of aggregate functions are available to perform calculations on questions within a repeating section or page, or a multiple row data source. For example, calculate the total price of individual line items or determine the average purchase order value for a particular client.
Aggregate functions require a reference to a question within a repeating page or section, which may be of any question type, or a multiple row data source question. Aggregate functions examine all the values retrieved to determine a result.