Forum Discussion

MariaKozmin's avatar
MariaKozmin
Qrew Member
3 years ago

Timesheet Issues - Day totals, etc

I'm having issues where for some reason, when I create a report based on the hours that are put into the daily timesheet, the data only shows an AVG and no Total. And I don't care about the Avg but would really like to see the total. Any help?
The time fields each day are in duration.

I also have an issue where I tried to do start/end day, but doing [End] - [Start] resulted in a WEIRD negative number, that did even make sense either way one could subtract the two numbers from each other.
Any ideas what could have gone wrong there?
Tables and fields

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    You can look at the field properties to tell Quickbase if you want totals and/or averages. 
    What field types are [End] and [Start]

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • MariaKozmin's avatar
      MariaKozmin
      Qrew Member
      3 years ago
      That the thing however- the place in field properties for that is correctly unchecked so the totals AND the average should show, and they don't. 
      End and start are both time (not 24hr clock)