Aggregate Functions inside Aggregate Functions RRS feed

  • Question

  • I know the above title does not work in SRS when you try it in layout.  What i am trying to do is to get a sum for distinct values for a certain column so that i can get a percentage with that total.  I have tried setting up COUNT(DISTINCT field) as Count  in the actual SQL, but that doesn't give me the correct number.  So I tried using just COUNT and it gave me the same number.  Any suggestions would be most helpful.
    Matt Murphy
    Friday, April 24, 2009 2:37 PM


  • Nevermind I figured it out.  All I neede to do was to do the second option for CountDistinct that asks for the Scope.
    Matt Murphy
    • Marked as answer by mmurphmsu Friday, April 24, 2009 3:03 PM
    Friday, April 24, 2009 3:03 PM