Find multiple values based on distinct id

Sun, 05 Feb 2017 06:53:06 GMT

Hi,

I am trying to write an expression which would list down the below table of all customers who are not following the below rule.

Rule to be followed is: One Project ID should only have a single Customer.

Eg:

I tried with aggregation function but couldn't figure out how to get the above solution

=aggr(if(Count(DISTINCT([Project ID]))=1,if(count(distinct([Customer Name]))>1,[Customer Name])),[Customer Name])

Please let me know the correct formula to achieve this

Re: Find multiple values based on distinct id

Anil_Babu_Samineni — Sun, 05 Feb 2017 16:07:29 GMT

What is the logic behind on this? How to justify which one you want to show in UI