Reporting: Counts in Excel and BI360

Reporting: Counts in Excel and BI360

Two methods for adding a record count to your reports: using the Excel COUNT function and BI360 Grouping Count.

About this course

Jim Hummer of Solver Support demonstrates two methods for adding an item count to reports using BI360 Report Designer. This lesson is applicable to both version 4 and version 5 of Report Designer.

Topics include:

  • Using the Excel functions COUNT and COUNTA to report on the number of items returned from an expanding row group
  • Defining a cell-based Grouping based on the Count option for a non-expanding row group
  • Adding filters for document type and void status

Posted 1/19

About this course

Jim Hummer of Solver Support demonstrates two methods for adding an item count to reports using BI360 Report Designer. This lesson is applicable to both version 4 and version 5 of Report Designer.

Topics include:

  • Using the Excel functions COUNT and COUNTA to report on the number of items returned from an expanding row group
  • Defining a cell-based Grouping based on the Count option for a non-expanding row group
  • Adding filters for document type and void status

Posted 1/19