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

[Katica_Deusing]

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]

Where do you want to calculate the balance?

[Katica_Deusing]

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

[Aleksi_Alkio]

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