I'm wanting to use this number (ElapsedDays) to calculate the average mean time based on months, i.e.,
Example: 179\30.4 should equal 5.88
My report field shows this calculation as: 6.00
No matter what I've tried, it rounds the number to the nearest whole number. When I set the report field properties to fixed, and or set the Decimal Places to "2"....it still rounds the number. I know they say it's best to change the format properties in the underlying table, but this number comes from a calculation performed in the query. I've also tried setting the Format propertys inside the query, but still it returns a whole number. Not sure what I'm overlooking. Since the ElapsedDays is coming from a Date field, would this prevent the decimal places from working?