Insert Run Report in Excel for Apps

Insert Run Report Feature in ExcelforApps
Insert Run functionality is used to return sum, count, max
etc for the datapoint(columns) in E4A Report. The value will be returned in the
cell once the calculation is performed. If the report is defined to run for the
specific parameters, then the Insert Run report calculation can also be made to
run for that parameter.
How to Create a Insert Run Report
Go to Excel4Apps Responsibility and click Insert Run Report
List of Reports will be displayed. Select the Report where
we need to create Insert Run functionality.
For example if we need to count the number of Employees in
the report, Select the Report output and click on any cell in the header
section. Then Click “Insert Run Report”. The below screen will be displayed

Now click Next and then add the Filters required for the
Count Operation to be manipulated. Users can enter upto 10 filters. The filters
will also be applied as in the report or also for the parameters not defined in
the report.
Add the filters and then Click Finish. The formula will be
calculated and displayed in the cell.

  • January 12, 2018 | 18 views
  • Comments