Friday, 12 January 2018

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.

No comments:

Post a Comment