Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to count the occurrences of Projects with more than 5 members.
So far I have constructed this formula:
=Count(DISTINCT if(count([Project Team Member Name])>5,[Project ID]))
but that isn't right. I think I am mistaking in the syntax - any ideas?
Hi, U can use this formula,
=if(Count([Project Team Member Name]))>5,count([Project ID]))
Hi,
Try this expression
=Count({<[Project ID]={"=Count(DISTINCT [Project Team Member Name])>5"}>} [Project ID])
Hope it helps you.
Regards,
Jagan.
Hi.
sum(
if(
aggr( count(DISTINCT [Project Team Member Name]),[Project ID])
>5,1,0)
)
Alessandro Furtado
ThnX!
ThanX Jagan,
I am new to this language… what is the logic behind the {} and <> ?
Grtz. Bart
Hi ThnX,
that is simple and straightforward.
Grtz. Bart
Hi All,
ThanX for your answers. Got three different results now, so will be checking which one is the right one.
Grtz. Bart
OK, that explains a lot. ThnX!