DISTINCT

[alemberg]

Folks the following expression is working for me within a KPI extension. I am however looking for the result to come back DISTINCT with the count. What do i need to add to this expression to make that happen.

Count({$<[Bank KPI - # of Clients pending On-Boarding]={Y}>}Client)

[srchagas]

did you try use?

Count(  DISTINCT {$<[Bank KPI - # of Clients pending On-Boarding]={Y}>}Client)

[sunny_talwar · Accepted solution]

May be this:

Count(DISTINCT {$<[Bank KPI - # of Clients pending On-Boarding]={Y}>}Client)