---
title: Build a SUM Report
slug: pl-check-links/build-a-sum-report
docTags: 
createdAt: 2026-02-23T07:45:14.233Z
---

A SUM report generates averages for specific items or animals within certain groups and presents details in a table or graph

![](https://api.qa.archbee.co/api/optimize/zICxj0dnLereb6UUrBA3-/bIykJ0j5KgVbJJTnhojLp_cmdbuilder-sum-example.png)

Follow the steps below to continue:

::::WorkflowBlock
:::WorkflowBlockItem
Use the search field at the top of the items list to find items by name or description. For example, searching for "sire" finds all associated items in your dairy: LSIR, MGSIR, PSIRC, SIR1, etc. See the [Build a LIST Report](docId\:ooA68QoDltnx-eU3jByxg) topic to learn more about using search.
:::

:::WorkflowBlockItem
To build your report, drag and drop items from the items list onto the **Report Output** area. Reorder the columns by dragging and dropping the item names

::Image[]{src="https://api.qa.archbee.co/api/optimize/zICxj0dnLereb6UUrBA3-/vdf2oFQDgM08tnRGjiGD8_cmdbuilder-edit-item58x25.png" size="10" isUploading="false" initialPath="../../../../Resources/Images/Platform/cmdline/cmdbuilder-edit-item_58x25.png" githubPath="Content/Resources/Images/Platform/cmdline/cmdbuilder-edit-item_58x25.png" position="flex-start" showCaption="false"}

or click the **x** next to an item name to delete it. See the [Build a LIST Report](docId\:ooA68QoDltnx-eU3jByxg) topic to learn more about reordering and deleting columns.

The SUM report automatically adds "AVG" to the item name when an item is dragged and dropped from the items list into the column header on the right side of the **Report Output** area.

::Image[]{src="https://api.qa.archbee.co/api/optimize/zICxj0dnLereb6UUrBA3-/fCnGYTpZ73lemRxieQ_0f_cmdbuilder-sum-avg.png" size="85" isUploading="false" initialPath="../../../../Resources/Images/Platform/cmdline/cmdbuilder-SUM-avg.png" githubPath="Content/Resources/Images/Platform/cmdline/cmdbuilder-SUM-avg.png" position="flex-start" showCaption="false"}

The SUM report also allows you to control how some animals are grouped by dragging and dropping items from the items list into a row beneath the **BY** column on the left side of the **Report Output** area. The first item dropped will become the first grouping on the report.

For example, if you drag and drop the PEN item and then drag and drop the LACT item beneath it, an animal grouping is created by pen and then by lactation.

![](https://api.qa.archbee.co/api/optimize/zICxj0dnLereb6UUrBA3-/wQ85RfRBNFh4E8chUIW2j_cmdbuilder-sum-group-by.png)

When the report is run, the results are grouped first by pen and then by lactation.

::Image[]{src="https://api.qa.archbee.co/api/optimize/zICxj0dnLereb6UUrBA3-/OWPqJJGeuKXkv7vzIwaET_cmdbuilder-sum-group-by-results.png" size="37" isUploading="false" initialPath="../../../../Resources/Images/Platform/cmdline/cmdbuilder-SUM-group-by-results.png" githubPath="Content/Resources/Images/Platform/cmdline/cmdbuilder-SUM-group-by-results.png" position="flex-start" showCaption="false"}
:::

:::WorkflowBlockItem
To set filters, drag and drop items from the items list into the **Filters** area, and then choose an **Operator** from the drop-down and set a **Value** for the operator. See the [Build a LIST Report](docId\:ooA68QoDltnx-eU3jByxg) topic to learn more about using filters.
:::

:::WorkflowBlockItem
In the **Switches** area, select to include alive, dead, or all animals in your report.

The SUM report also allows you to control how some calculations are handled by checking one or both of the following boxes:

- Include zero values in averages and standard deviation calculations. Without the switch, average, standard deviation, mode, and medianPULSE calculations include non-zero values only.
- Use sample values for standard deviation calculation. Without the switch, PULSE calculates population standard deviation.
:::

:::WorkflowBlockItem
Click **Save and Execute** to build your report and display the results of the report on the [ReportWorklistResults.htm](docId\:ccHmaj9YUZYEy8iPIgX5C)[Reports/Worklists Results](docId\:ccHmaj9YUZYEy8iPIgX5C) page.DC Unlimited subscribers can also preview the command as the report is being built.
:::
::::

[\< Return to Report/Worklist Builder OVERVIEW](docId\:t5pfVF-Dp1aqSy8LDc7kn)