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

    Analytics reports: sum incorrectly calculated

    • 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
    • Was this article helpful?