UNIQUE Function

From Planfix
Revision as of 06:36, 23 April 2024 by Dmitri (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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.


Go To

Retrieved from "http://planfix.com/help/index.php?title=UNIQUE_Function&oldid=20384"