1 of 1 people found this helpful
Is this the formula you are looking for?....
COUNTD(IF NOT([No Collected]) THEN [Unique ID] END)
As a True/False field you don't need an Equals False, and also you don't want an else part. Anything that isn't NULL get's counted in a COUNTD...so your ELSE 0 would get counted one, but by not having any ELSE part (or you could do ELSE NULL END) anything that is True gets a NULL assignment and so doesn't get counted in your COUNTD. You can then just do a COUNTD([UniqueID]) to get the %age.
Hope I've understood correctly, but if not please post back.
Thank you very much for your quick reply. I just figured it out by myself. The statement I use is as follows.
COUNTD(IF [No Collected] = FALSE THEN [Unique ID] END)
And yours works fine as well. Thanks.