13 Replies Latest reply on May 4, 2012 9:03 AM by TC

    Sub-Summary Report does not show correct Total Values



      I have 3 tables:



      Filter Requirements Field
      RatingOfFilter (Text)
      SizeOfFilter (Text)
      RatingSize (Calculation appending two previous Fields)
      Qty (Niumber)
      Total Qty (Summary Calculation - Total of Qty)




      Join Table


      When I create a list layout using the Filter table , output is correct correctly showing all filter records with the correct month(s).
      When I add a Sub-Summary part above with the break field on Months and another Sub-summary part above and below (below for testing) with the break field on RatingSize, the output is correct after I sort on Months and RatingSize
      However, when I add the Total Qty field to both the upper and lower sub-summary part with the break field as rating size, I get two different values and neither is correct:
      for the above part, I get the value for the first record in the break area
      For the below part, I get the value for the last record in the break area


      The only time the values are correct is when there is only on filter of X for a specific month.


      Any ideas?


      Thanks in advance