Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Alma

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Alma
    3. Knowledge Articles
    4. Analytics reports: sum incorrectly calculated

    Analytics reports: sum incorrectly calculated

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Description
    2. Resolution
    • Product: Alma

    Description

    In an Analytics report, calculating the grand total for a column shows an incorrect result. It is supposed to display the sum of the above rows, but the number is incorrect, or the sum does not show at all.

    Resolution

    This can be caused by the Aggregation Rule not being set to "Sum." OBI automatically applies a default Aggregation Rule when totaling a column. Depending on the data type, this may not be set to sum.

    This setting can be changed in two places.

    On the Criteria tab:

    1. Select the column that is being totaled and click "Edit formula"
    2. Select the dropdown menu for "Aggregation Rule (Totals Row)" and choose "Sum"
      aggregation_rule_sum.PNG
    3. Run the report and check that the sum is now calculated correctly

    On the Results tab:

    1. Click the pencil icon to edit the table view
      Pencil icon to edit the view for the table
    2. Identify the column that is being totaled and click "More Options..."
    3. Check the setting for the Aggregation Rule. If it is set to "Default," change it to "Sum"
      Aggregation Rule in the edit view interface is set to default
    4. Run the report and check that the sum is now calculated correctly

    • Article last edited: 28-Oct-2019
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Analytics Reports Failing to Open / Export
      • Analytics Session Timeout
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Documentation
      Language
      English
      Product
      Alma
    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