Is it possible to customize the Task cost calculation?
I have a question on how to customize the calculation of Task costs.
A bit of context: in my research organization, most of our research projects are funded by institutions (European Commission, regional agencies, …), which funding rates differ between each other. Example: the EC reimburses all direct costs (i.e. personnel + equipment + travel) and adds 25% of indirect costs rate; a regional agency reimburses only 10% of indirect costs and they only apply to the personnel costs.
I have created a Project custom field for the funding scheme (EC, …) and some custom fields for our resources (Manpower, Equipment, Travel, …). My objective is to create a custom Cost1 field which would test the type of funding scheme and the cost category, and apply the corresponding formula.
The problem is that I don’t see how to access the resource individual costs under the Task Usage view, it seems the formulas only apply to the total cost of the Task.
Does anyone have a clue of how I could achieve what I need? I hope the explanations above were clear enough.
Thanks in advance!
Christophe.
I have a question on how to customize the calculation of Task costs. A bit of context: in my research organization, most of our research projects are funded by institutions (European Commission, regional agencies, …), which funding rates differ between each other. Example: the EC reimburses all direct costs (i.e. personnel + equipment + travel) and adds 25% of indirect costs rate; a regional agency reimburses only 10% of indirect costs and they only apply to the personnel costs. I have created a Project custom field for the funding scheme (EC, …) and some custom fields for our resources (Manpower, Equipment, Travel, …). My objective is to create a custom Cost1 field which would test the type of funding scheme and the cost category, and apply the corresponding formula.The problem is that I don’t see how to access the resource individual costs under the Task Usage view, it seems the formulas only apply to the total cost of the Task. Does anyone have a clue of how I could achieve what I need? I hope the explanations above were clear enough. Thanks in advance! Christophe. Read More