Calculation Condition KPI

[Anonymous]

Hi Folks,

I have a column where duplicate entry is there and while selecting KPI with count it is counting even duplicate values so can anybody let me know how to avoid duplicate values so that I can get a exact count.

Thanks & Regards

[rwunderlich · Accepted solution]

Add the DISTINCT keyword to your count function.

-Rob

[Anonymous]

Thanks Rob, it worked. Keep in touch as I am new to this.

Regards

Bishnu