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"
epicazoAsked:
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")
0
 
cyberkiwiCommented:
Using the report designer, find the properties of the cell that has this formula and enter the Format as "N2"
0
 
epicazoAuthor Commented:
Please note that I am presenting a combination of TEXT + Number so N2 will not work.  :(
0
 
epicazoAuthor Commented:
Awesome!    thank you so much!
0
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.