Post reply

SUM of COUNTDISTINCT in SSRS

  • September 23, 2015 at 10:44 am

    #300971

    Hi,

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

    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 because I get an error on using SUM.

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

    Thanks.

  • September 24, 2015 at 3:50 am

    #1829069

    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.

    Could somebody please advise on this ?

    Thanks.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply