pwalter83 (9/23/2015)

---

Hi,

I have an issue wherein I need to do a normal SUM in the bottom row of the COUNTDISTINCT in the above row. It returns an incorrect value if I use COUNTDISTINCT again.

I have attached a screenshot to explain my problem. The sum for the year 2015 should be 14342 but its shows 14327 which is incorrect. I don't know what to use in place of COUNTDISTINCT.

Can someone please advise on this ? Would really appreciate it.

Thanks.