How do I total from one table (tasks status="done" sum total hours) - I can create that view.
Then compare that total (by client) against a value held on the client table (budget hours) to show percentage used so far this month.
ID 766
Category Customization
Author
Philip Evans
Date Created 10/3/2014 2:21:20 AM
Date Updated 10/3/2014 8:50:16 AM
Comments
Mila Shvets Staff 10/3/2014 8:50:16 AM
If two tables are related, you can create a summary column calculating the number of hours in the master table. You may read more about summary column creation here http://www.teamdesk.net/help/4.5.aspx After that you can create a Formula column calculating percentage. You may read more about Formula columns here http://www.teamdesk.net/help/4.6.16.aspx
If you encounter any difficulties, please open a new question in TeamDesk support portal.