DISTINCT
Requires: Write access to configure a questionnaire calculation.
Removes duplicate items, preserving first occurrence order. Input: text or numeric lists. Output: a combined text list with Per item off, or one deduplicated list of the original type per input with it on.
Example: ['walk', 'rest', 'walk'] → ['walk', 'rest']. Text is trimmed and blanks removed. In aggregate mode numbers become text; 2.0 and 2 can remain different text items.