How to convert an Excel formula from SSRS report

Posted By Posted by: Ahmed Taee on October 25, 2016

Blog_Blue Bar Skinny

In your report, create a field that will be a formula field when the report is exported to Excel.

In the example below, the cell underneath Results column header will be the summation of First Value plus Second Value.

1

 

The expression content will be “=C3+D3”
2

 

Run the report and export it to Excel
3

 

To convert it to an Excel formula, go to cell B3, Press F2 and click Enter
4

 

Hope this works for you!


Blog Posted In Blog Posted In: Blog, How to, Reporting, Uncategorized
Blog Posted In 

Leave a Reply

Your email address will not be published. Required fields are marked *