Decimal into Visual Studio field

Hi,

I am trying to modify a field that currently displays numbers as integers "4/4" to display with a decimal. But, only the numerator, ideally it would look like "4.2/4" with only one decimal place.

Thanks!!
=Int(Avg(DateDiff("d",Fields!ORDER_DATE.Value,Fields!SHIPPED_DATE.Value))) & " / " & (Int(Avg(Abs(DateDiff("d",Fields!PROMISE_DATE.Value,Fields!ORDER_DATE.Value)))))

Open in new window

Hoyt81Asked:
Who is Participating?
 
Megan BrooksConnect With a Mentor SQL Server ConsultantCommented:
You could use Round() on the numerator instead of Int(). See code snippet below. This example rounds to 1 decimal place.
1:
 =Round(Avg(DateDiff("d",Fields!ORDER_DATE.Value,Fields!SHIPPED_DATE.Value)), 1) & " / " & (Int(Avg(Abs(DateDiff("d",Fields!PROMISE_DATE.Value,Fields!ORDER_DATE.Value)))))
 

Open in new window

0
 
Hoyt81Author Commented:
Exactly what i needed!
Thanks!
0
 
planoczCommented:
Way to go rscowden you made it to Masters!! :)
0
 
Megan BrooksSQL Server ConsultantCommented:
Thank you! I work at a non-profit association as the sole developer, doing mainly Microsoft BI and with help only from an IT consultant who manages the servers. It can be lonely sometimes, and EE lets me stay in touch with other people that speak the same language. :-)
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.