5 Replies Latest reply on May 13, 2013 1:45 PM by Ryan Johnson

    SUM on Unique ID

    Ryan Johnson

      Okay, this seems pretty straightforward but I seem to be having brain freeze or am over complicating things.  In the attached image, I need to SUM the PROJECT_TOTAL based off Q_QUOTES_QUOTE_ID.  I tried: SUM([PROJECT_TOTAL])/COUNTD([QUOTE_ID]) cause I thought that would give me the right denominator, but my numbers seem to be coming out too low.  In this particular example, I would expect (want) the five unique IDs to total up to $365,780.

       

      screengrab.png

      Any suggestions?