Link to home
Start Free TrialLog in
Avatar of Hoyt81
Hoyt81Flag for United States of America

asked on

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

ASKER CERTIFIED SOLUTION
Avatar of Megan Brooks
Megan Brooks
Flag of United States of America 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 Hoyt81

ASKER

Exactly what i needed!
Thanks!
Avatar of Howard Cantrell
Way to go rscowden you made it to Masters!! :)
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. :-)