Hello,

I was wondering if anyone can help me with my problem. I am working on an utilization screen (and report) for machine inventory. This report is pretty simple. I am only using the Sub-summary parts to display the totals for each group (CB_GRP), category inside the group (CDK_MODEL::MODEL_CAT) to the individual units ( CB_ORD). I can’t figure out how to count the units inside each Sub-summary. I draw the final result on the screenshot to be perfectly clear. I am sure the Getsummary is the function I need to be using but it is just not working 2 hours later

Thank you for your input.

Ales

Ah! That makes sense. I hadn't noticed that you were showing TWO sub-summaries and no body part.

The solution for this is to create a second summary field, but this time use the "List of" option (let's call it "sumListOfOrders"), and select the CB_ORD field to summarize. Next, create a calculated field with the following formula:

ValueCount ( UniqueValues ( GetSummary ( sumListOfOrders ; MODEL_CAT )))

I think that should calculate the total number of units under each Model Category.