UNIQUE Function: Difference between revisions
From Planfix
(Created page with "{{#seo: |title=UNIQUE Function |titlemode=append |keywords=planfix, Functions, UNIQUE, UNIQUE Function |description=UNIQUE Function }} The UNIQUE() function returns a list of unique values in a list or range. == Format == '''UNIQUE('''reccuring_variables''')''' == Example == <pre>%%%UNIQUE({{DataTag.Actual working time."Employee.?".Name}})%%%</pre> The result is a string with unique values separated by commas: <pre>Denis,Alex</pre> == Important == The function is av...") |
|||
| Line 18: | Line 18: | ||
== Important == | == Important == | ||
The function is available in [[Calculated fields|calculated fields]] and [[Variables in Text#Example|text with variables]]. | *The function is available in [[Calculated fields|calculated fields]] and [[Variables in Text#Example|text with variables]]. | ||
== Go To == | == Go To == | ||
*[[Standard functions|Formulas]] | *[[Standard functions|Formulas]] | ||
Revision as of 12:43, 24 October 2024
The UNIQUE() function returns a list of unique values in a list or range.
Format
UNIQUE(reccuring_variables)
Example
%%%UNIQUE({{DataTag.Actual working time."Employee.?".Name}})%%%
The result is a string with unique values separated by commas:
Denis,Alex
Important
- The function is available in calculated fields and text with variables.