Link to home
Start Free TrialLog in
Avatar of epicazo
epicazoFlag for United States of America

asked on

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"
Avatar of cyberkiwi
cyberkiwi
Flag of New Zealand image

Using the report designer, find the properties of the cell that has this formula and enter the Format as "N2"
ASKER CERTIFIED SOLUTION
Avatar of cyberkiwi
cyberkiwi
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of epicazo

ASKER

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

ASKER

Awesome!    thank you so much!