Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
Use Count(Distinct DecisionID).
Distinct keyword selects only unique data.
Celambarasan
Hi,
Use Count(Distinct DecisionID).
Distinct keyword selects only unique data.
Celambarasan
Hi,
Try using the Distinct option in Count()
=Count(Distinct DecisionID)
Regards,
Jagan.