I'm having trouble with a formula

Kym

I want to count the number of Unique Programs when Project Status = Active and Department = Professional Services

Based on my example I should get the count of 4

I have tried several combos of COUNT and DISTINCT but may syntax is all wrong

Melissa Yamada

Hello @Kym

Try:
=COUNT(DISTINCT(COLLECT({Program}, {Project Status}, "Active", {Department},"Professional Services")))

Make sure to select the corresponding reference columns on your formula.

Kym

Thanks Melissa - it parses now (YAY) but gives the incorrect value in my real data….