I have my main table (Project), which is the app that contains the general project information (Name, type, creation date, owner, etc). Within this is a relationship to another table, that allows the developers to 'code' their time to the project (Dev_Hours). The sum of the entries are then displayed in the Project table as Total Design Hours.
So next, I would like to take the Dev_Hours sum and, in a new field, output a cost.
For example let's say it costs an average of $65 dollars per hour to develop and there are 12 Dev_Hours input, I would like to create an additional field (next to Total Design Hours) in the Project that displays the cost.
Hope that helps - and this may be a very simple formula to do, but I am struggling with this one...
Thanks in advance for your help and please let me know if you need any additional information.
