3 Replies Latest reply: Aug 13, 2018 6:46 AM by Mo Abdolrahim RSS

    Summary Measure limit not working?

    Tiffany Seeland

      I have a measure limit on my last key field to show only non zero records.  I can't get it to work.  Do I have it setup incorrectly?

       

       

       

       

       

       

      Version 13.5.0.6554

       

      Thanks,

      Tiffany

        • Re: Summary Measure limit not working?
          Mo Abdolrahim

          Hi Tiff,

          The Measure limit option in the summary is little tricky.  This option builds a summary using only those key fields where a selected measure’s subtotal value meets either an upper limit or a lower limit.  Since I cannot see your entire dataset it is hard to say if it's not working or it's working..

          Please note that this option is for a select measure's subtotal (not every single row in the summary).

          I created two summaries one without any measure limit (the left side) and another one with measure limit, which set deduction= 0 (the right side).

          You notice that when a subtotal of a specific account number (such as 10073) is all zeros then it is displayed in the sum-limit_EQ_0 summary (left side).  When a subtotal of a specific account number is not zero (such as 11887) then this account number is not listed in the sum-limit_EQ_0 summary.

          I believe this option works as describes in the help.

          You may want to create a calculated field (gross), and set a filter where gross is not zero. Then create a summary and assign the filter to the summary. 

           

          Regards

          Mo

            • Re: Summary Measure limit not working?
              Tiffany Seeland

              Ok Mo, I think I understand...I do want the measure subtotal, and not the individual rows.  I have a Vendor that likes to send us reports that DO NOT FOOT.  That means that the detail lines DO NOT add up to the total printed on the report.  I'm looking for by store, if the total does not work, use the printed total #.  If the total does work, go with the addition of the detail lines, as we need by flavor information.  Here is my trapping and data set for 1 that does not work:

               

               

               

              UNFORTUNATELY, the total of $4646.01 is ACTUALLY correct and the detail provided is WRONG.  :,(  Since we need line item detail for a different situation not presented here, we were forced to go line by line.  I'd like to at least quickly identify each time this happens, even if we have to manually fix it.

               

               

               

               

              I haven't been able to get the sort by Expression using Gross to work, either.  Is there still hope for me?

               

              I couldn't get your suggestion of a filter=0 to work on the summary...instead this happens:

               

               

              Many thanks for your time!

              Tiffany

                • Re: Summary Measure limit not working?
                  Mo Abdolrahim

                  Hi Tiff,

                  I created a mockup sample report with total. On some pages the total amount and unit price do not match the total details (adding up all amount s and unit prices for every detail line per account number).  Per screen shot below, the total on page 1 does not match the total amount for each detail.

                  I created a summary that will show me which account number the total amount per detail does not match total amount at the bottom of the page.

                  I used the following expression to display which account numbers total are not zero and which ones are zero.  The amount field is for every amount detail, and the T_amount field is the total amount for all amounts per account number.

                   

                  SUM([Amount])-max(T_Amount).