Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Voyager
    Ex Libris Knowledge Center

    Simple overview of totaling a value in Voyager Prepackaged Access Reports

    1. Last updated
    2. Save as PDF
    • Product: Voyager
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

     

    Question

    Provide an example of how to total values in Prepackaged Access Reports.

    Answer

    Let's say we want to determine how much each patron owes.

    We would want to use "Group By" and select the "Sum" Aggregate Function option in the dropdown.  Aggregate Functions work on Groups of Rows. Sum provides the total values in a field.

    We'll use the FINE_FEE table.  You should note that in this table when the fine is paid (or waived or whatever), the FINE_FEE_BALANCE goes to 0, but the record is never deleted.

    clipboard_e73aeb7103f103a7f89d1811fe3681515.png

    Pull down the fields you want to report on, and click the Sigma Tool clipboard_ed7c00e7592965968bb373580854e23c7.png so that you get a "Total:" row.

    Using the drop-down, change the "Group By" to "Sum" for FINE_FEE_BALANCE.  Run your query:

    clipboard_ef17fee07375ba8ad60d7583561e35726.png

     

    Constructing custom SQL queries by request and troubleshooting unexpected results from customer-created SQL queries falls outside the scope of Support. The above has been posted for informational purposes.  Voyager-L and Developer Network are useful resources for finding helpful custom SQL or obtaining assistance from peers in troubleshooting custom queries.

     

    • Article last edited: 21-May-2021