Overview

Once a report is created and published it is common to come back and update the report at some point in the future. 

This article covers how to go into an existing report and modify or delete functions that are already there.

Details

To edit certain areas of a report, the user must first check the report out for editing. The user can check the report out by clicking on the ellipsis icon in the lower-right corner of the report's card and then click Check Out. This will move the report into the user's Workspace.

It is important to note that only users with the Report Editor role assigned to them can edit reports. Report Viewers can only run report, not edit them.

When the user clicks the Check Out button it will move their report to their Workspace and will automatically open the report for them in Excel Online. 

How to Modify an Existing Function

To modify a function that already exists, the user will click on the desired function's cell in Excel and then open the Cosmos Task Pane if it isn't already open. 

Click on the Range Lists tab and then click EDIT on the Range List to allow changes to be made. When editing a Range List function, the user can expand the different sections of the Range List to make their changes. After all changes have been made, click the SAVE button. 

How to Delete a Function

To delete a function the user would click the cell that contains the function, navigate to the Cosmos Task Pane, and then go to the appropriate tab, such as the Range Lists tab or the Field Lookups tab. 

Once there, the user will click the Delete button in the upper-right hand corner of the function's area. An example of this is shown below highlighted in red.

Clicking the DELETE button will remove the function from the report. Once a function has been deleted it cannot be undone, and if the user wanted it back, they would need to re-add the function to the report.