Hello, I'm wondering, is there a function i...

expressions
(Jenn M.) #1

Hello,

I’m wondering, is there a function in AppSheet similar to COUNTUNIQUE from Google Sheets? Or perhaps just UNIQUE?

I’m still new to expressions, but here’s what I’m trying to write: IF(COUNTUNIQUE(SELECT(Employees[Garment Type], [Company]=[_THISROW].[Company]))>2, “result if true”, “result if not true”)

Thanks

(Praveen Seshadri (AppSheet)) #2

Yes, the optional third input to SELECT() tells it whether or not to eliminate duplicates.

(Jenn M.) #3

Perfect, thanks!

(Suvrutt Gurjar) #4

Hi @Jenn_M I request you to evaluate following

IF(COUNT(SELECT(Employees[Garment Type], [Company]=[_THISROW].[Company], TRUE))>2, “result if true”, “result if not true”)

Please note that in the above expression, the select statement itself selects unique (duplicates free) values in the list. Count merely counts those unique values in the list. I believe the end result is same.