I’m stuck and was hoping someone may be able to help?
I’m trying to add up the “Day Total” for each day of this week (for Jane) which would be 1.1 hours. Here is my data base setup. Day total is an integer, Date of hrs is a date.
And here is an image of the calendar (I’m using the RG calendar) with some notes.
And some screen shots of what I’ve tried.
- Time Entry’s to date (of total hours), so Im able to get all entry’s by a user (but I only need this week and these are not added together)
- Number of Entry’s
- Total hours of all dates
TimeEntrys:each item's Day total:sum gets me really close because it is adding up all of the day totals ever entered but I only need the day totals for this week. And I can’t figure it out…
Oh and I do have access to Calendar Week A’s First day / Last day etc. from the RG Calendar but by using this I haven’t been able to get a number probably because its a date? and usually causes the text field to turn blank.
So close and yet so far away