TeamDesk Knowledge Base & Support

Home

FAQ

Forum

My Stuff

Help

Uniques()

Uniques(<any> x, <any> y, <any> z) returns the number of unique arguments.

ID
1165

Category
TeamDesk

Author

Robert Gustavsson

Date Created
1/19/2018 3:02:45 AM

Date Updated
1/22/2018 2:22:48 AM

Status
New Idea

Score
30

Promoted By

Patricio Bustos

Nick Ashcroft

Robert Gustavsson

Comments

	Nick Ashcroft 1/19/2018 3:04:30 AM I think this is probably the same as https://teamdesk.crmdesk.com/answer.aspx?aid=23075
	Slava Shinderov Staff 1/19/2018 3:26:17 AM What's the problem you are trying to solve?
	Robert Gustavsson 1/19/2018 3:37:08 AM Avoid nested IF-clauses that grow exponentially with the number of arguments.
	Slava Shinderov Staff 1/19/2018 3:57:49 AM Can you describe your problem from business side? What's the source of these duplicates in the first place? May be incorrect/non optimal data structure is the cause of duplicates?
	Robert Gustavsson 1/19/2018 4:54:32 AM We have some paint options and startup cost depends on the number of unique colors.
	Robert Gustavsson 1/22/2018 2:22:48 AM I think there needs to be a version of the function where Null values are ignored.

Feedback