I am pulling projected cost into Excel reports and an external db. Part of the monthly projections are to update the project overheads. So I need to accurately pull monthly cost as well as write monthly cost to the overheads tasks.
I am having trouble understanding why would you read and write to an Assignment instead of directly to the cost Resource?
Read the month cost by resource (simplified):
There is only one TimeScaleValue in tsvs (the single month) so I believe that I'm fine just referencing tsvs(1).Value instead of having to increment through the collection.
Read month cost with assignments:
And finally write the month overhead cost to the overhead task:
This method works for me but I am frustrated I cannot get it to work writing directly to the resource cost. I don't really understand why I would have to read or write to an assignment (either task or resource) instead of directly to the resource itself. Could anyone explain why one should read and write costs using assignments or if there is a better way using the resources directly?
Thanks for your time.
asked Jun 2 '15 at 20:58