Hello, I want to create a function where I have a project which has a goal for time spent on that project. Then in a sub table which is my time sheet I can add an entry for time spent on the
project.
So if the goal is 8th and I have 3 entries in the timesheet… 2h, 1h, 4h. How can I sum those entries and compare to the 8h. So it will show me if I’m
on target or above or below target?
Where do you want to calculate the balance?
In the table with the projects… it needs to be set in comparison to the target time…
When you have a related Timesheet table (child table), you can calculate the balance like [Goal] - SUM(SELECT([VirtualListColumn][TimeSpent],TRUE))
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |