epicazo
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"
Using the report designer, find the properties of the cell that has this formula and enter the Format as "N2"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Please note that I am presenting a combination of TEXT + Number so N2 will not work. :(
ASKER
Awesome! thank you so much!