How to count same value only one time?

[#1]

Hi

I have a table with decision and subdecision. Each subdecision are connected to the main decision by a decisionID. I want to count the decisionID but only ones. So, what function do I use to only count uniq IDs?

551

552

553

551

as only 3 posts?

/Thanks!

[CELAMBARASAN · Accepted solution]

Hi,

     Use Count(Distinct DecisionID).

     Distinct keyword selects only unique data.

Celambarasan

[jagan]

Hi,

Try using the Distinct option in Count()

=Count(Distinct DecisionID)

Regards,

Jagan.