title: COMPUTE SUM is not working properly
body: <p>I have been working on the following query and cannot get it to COMPUTE:</p>
  
  <pre><code>BREAK ON "Package ID" SKIP 2 on report
  COMPUTE SUM OF "Package Cost" ON "Package ID"
  COMPUTE SUM OF "Package Cost" ON REPORT;
  Select distinct p.PkgID "Package ID", p.PkgName "Package Type", to_char(p.PkgCost,  '$99.99')"Package Cost", c.CustFName || ' ' || c.CustLName as "Customer Name" 
  FROM Subscription s, Package p, Customer c
  WHERE p.PkgID = s.PkgID
  AND c.CustID = s.CustID     
  AND trunc (s.startdate)=to_date('Oct 01, 2012', 'Mon DD, YYYY')
  ORDER BY p.PkgID;
  </code></pre>
  
  <p>The Output looks like this:</p>
  
  <pre><code>Package ID Package Type    Package Cost  Customer Name                                                                                                                                                  
  ---------- --------------- ------------- ---------------------------------------------------                                                                                                            
   10101 Movies Galore    $30.00       Frank Cinatra                                                                                                                                                  
         Movies Galore    $30.00       Krystal Carter                                                                                                                                                 
  **********            -------------                                                                                                                                                                
  
  
   20202 News Globe       $30.00       Billy Joel                                                                                                                                                     
         News Globe       $30.00       Dia Nelson                                                                                                                                                     
         News Globe       $30.00       Rhonda Shields                                                                                                                                                 
  **********            -------------                                                                                                                                                                
  
  
   30303 Total Watcher    $40.00       Frank McMann                                                                                                                                                   
         Total Watcher    $40.00       Orlando Magic                                                                                                                                                  
  **********            -------------                                                                                                                                                                
  
  
   40404 Couch Potato     $50.00       Allan Bubbles                                                                                                                                                  
  **********            -------------                                                                                                                                                                
  
  
                         -------------               
  </code></pre>
  
  <p>Cannot get it to Compute the Costs.It breaks the packages up fine, even puts in the dividing line, just no totals. Won't label as well.  Am I just missing something stupid?    </p>