How to Insert a Formula on Report Exported Excel File?

Follow the below steps to insert a formula in the report exported as an Excel file:

You can only insert a formula to get the sum of all the entries in a certain column once the values in this column are converted as numbers. 

• Once the report has been exported as an Excel file, make sure that editing is enabled. Scroll to the column where you want to add a formula.

• Highlight the entries that are needed for the formula.

• Once the entries are highlighted, click on the 'i' icon and click on 'Convert to Number'.

• Since the entry values have met the requirement, you can now add/ create a formula in Excel for the said column/entries.