<div>
Using the report designer, find the properties of the cell that has this formula and enter the Format as &quot;N2&quot;
</div>


<div>
Please note that I am presenting a combination of TEXT + Number so N2 will not work. &nbsp;:(
</div>


<div>
Awesome! &nbsp; &nbsp;thank you so much!
</div>


<div>
<div class="content wysiwyg-content">
<br />
=&quot;Avg LOS: &quot;+cstr(EXP(SUM(LOG (Fields!LOSD.Value)) / COUNT(fields!LOSD.VALUE)))<wbr /><br />
<br />
Results &nbsp; &quot;Avg LOS: 9.151836258&quot;<br />
<br />
Preferred Results: &quot;Avg LOS: 9.15&quot;
</div>
</div>



="Avg LOS: "+cstr(EXP(SUM(LOG (Fields!LOSD.Value)) / COUNT(fields!LOSD.VALUE)))

Results   "Avg LOS: 9.151836258"

Preferred Results: "Avg LOS: 9.15"

Using the report designer, find the properties of the cell that has this formula and enter the Format as &quot;N2&quot;

Please note that I am presenting a combination of TEXT + Number so N2 will not work.  :(

Format Column output in SSRS


=&quot;Avg LOS: &quot;+cstr(EXP(SUM(LOG (Fields!LOSD.Value)) / COUNT(fields!LOSD.VALUE)))

Results   &quot;Avg LOS: 9.151836258&quot;

Preferred Results: &quot;Avg LOS: 9.15&quot;

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.