UNIQUE Function: Difference between revisions
From Planfix
No edit summary |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 5: | Line 5: | ||
|description=UNIQUE Function | |description=UNIQUE Function | ||
}} | }} | ||
The UNIQUE() function returns a list of unique values in a list or range. | The UNIQUE() function returns a list of unique values in a list or range. | ||
== Format == | == Format == | ||
'''UNIQUE('''reccuring_variables''')''' | '''UNIQUE('''reccuring_variables''')''' | ||
== Example == | == Example == | ||
<pre>%%%UNIQUE({{DataTag.Actual working time."Employee.?".Name}})%%%</pre> | <pre>%%%UNIQUE({{DataTag.Actual working time."Employee.?".Name}})%%%</pre> | ||
| Line 16: | Line 15: | ||
<pre>Denis,Alex</pre> | <pre>Denis,Alex</pre> | ||
== 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]] | ||
Latest revision as of 13:16, 28 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.