How to use the average function on HH:MM:SS fields in Report Builder 3.0
Posted on 2013-11-05
I have a field in HH:MM:SS format and I would like to add an average at the bottom of my table report. I receive an error when attempting to use AVG in a calculated field. If I try to use the matrix report option, I loose my HH:MM:SS formatting and basic format options won't return it. Any suggestions are greatly appreciated.