Hoyt81
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!!
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)))))
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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. :-)
ASKER
Thanks!