Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Knowledge Articles
    4. Simple overview of totaling a value in Voyager Prepackaged Access Reports

    Simple overview of totaling a value in Voyager Prepackaged Access Reports

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Simple overview of counting things in Voyager Prepackaged Access Reports
      • Simultaneous Search fails when boolean operators not included in keyword search definitions
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved