The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.
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
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
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. RegardsMo
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!
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
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).
Join us for a community conversation on how High-Performance Computing (HPC) and Simcenter PSIM work together to meet the increasing demands of modern power electronics simulation. During this one-hour technical session, you'll discover how leveraging HPC can speed up simulations, improve scalability, and empower engineers…
Join us for a community conversation on accelerating your motor simulation workflow with Simcenter Simlab. In this beginner-friendly session, we'll introduce the platform's automated model-building capabilities and show how easy it is to set up your first electric motor analysis. You'll see the basic steps of geometry…
Join us for a Community Conversation where we'll discuss practical approaches to analyzing complex electromagnetic models using hybrid solver techniques. This session will provide a general overview of how different computational methods can be combined within a single simulation to address models containing varied…
