Why is summary report averaging totals in days for one item and in hours for another?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Calculated column is highlighted in yellow. This is a summary report. Why is 03. PT 1 32 21.75 hours averaging in hours instead of days?

AVERAGES

01. DW 1 40 -2.125 days 02. DW 2 38 2.8684210416667 days 03. PT 1 32 21.75 hours

Photo of Lynne8817

Lynne8817

  • 600 Points 500 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb
If you have a duration field, it probably defaults to "smart units" where it uses its best judgment as to the appropriate Units for time measurements. But on the field properties, you can force it to Days or Hours, for example.
Photo of Lynne8817

Lynne8817

  • 600 Points 500 badge 2x thumb
My summary report is based on a table report....the Calculated Column does not give me an option to change its "Field Properties".
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb
Sorry, i did not realize that it was a calculated column.  I suggest that you make a real field then.