Mark,
So how might I do this?
The "This Week's Hours" you helped on is working dead on. Now, in the same Team Table I want to create a "This Week's Projected Hours" based on how many associates currently have hours for the week then multiply that by 9.5 hours per day by how many days we are into the week.
I know this is not correct, but is what I tried
var text THISWEEK ="{8.IR.'this wk'} AND {17.EX.'"& [T-Team Number]&"'} AND {7.EX.'Regular Hours'}";
Count(GetRecords($THISWEEK,"bsa4dgc7x"))
I saw your post of how you worked in the Record ID, but not sure how to work that into this.
My ultimate goal is to have this as a barchart of hours vs expected hours on the managers dashboard.
------------------------------
Hans Hamm
------------------------------