Format Column output in SSRS

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

Results   "Avg LOS: 9.151836258"

Preferred Results: "Avg LOS: 9.15"
Who is Participating?
cyberkiwiConnect With a Mentor Commented:
Sorry, didn't see the text around the value

="Avg LOS: "+ Format(EXP(SUM(LOG (Fields!LOSD.Value)) / COUNT(fields!LOSD.VALUE)), "N2")
Using the report designer, find the properties of the cell that has this formula and enter the Format as "N2"
epicazoAuthor Commented:
Please note that I am presenting a combination of TEXT + Number so N2 will not work.  :(
epicazoAuthor Commented:
Awesome!    thank you so much!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.