Hello, I want to create a function where I ha...

(Katica Deusing) #1

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?

(Aleksi Alkio) #2

Where do you want to calculate the balance?

(Katica Deusing) #3

In the table with the projects… it needs to be set in comparison to the target time…

(Aleksi Alkio) #4

When you have a related Timesheet table (child table), you can calculate the balance like [Goal] - SUM(SELECT([VirtualListColumn][TimeSpent],TRUE))