Build a SUM Report

a sum report generates averages for specific items or animals within certain groups and presents details in a table or graph follow the steps below to continue 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 , mgsir, , , etc see the build a list report docid 8guaxr3 afprwhzbalkdp topic to learn more about using search 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 or click the x next to an item name to delete it see the build a list report docid 8guaxr3 afprwhzbalkdp 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 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 item and then drag and drop the item beneath it, an animal grouping is created by pen and then by lactation when the report is run, the results are grouped first by pen and then by lactation 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 8guaxr3 afprwhzbalkdp topic to learn more about using filters 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 calculations without the switch, average, standard deviation, , and pulse calculations include non zero values only use sample values for standard deviation calculation without the switch, pulse calculates population standard deviation click save and execute to build your report and display the results of the report on the see reports/worklists results docid\ aglfbf bfmbcntpjdr w3 page dc unlimited subscribers can also preview the command as the report is being built