summary of assignements custom field in resource row

[Piotr Zygadlo]

Hi,

I asked this question on general newsgroup, and I was redirected here

So, I have cost1 field in assignment (filled with VBA macro from FAQ 37) and
there are two problems:

1. How to summarize value of cost1 from all assignments to cost1 in resource
row? And not everyone assignments but just this on current view (Its easy to
do this for all assignments, but I want it to work exactly the same way as
Cost etc.

2. Why is this filled with VBA field don't work with standard functions as
[Cost3] = [Cost1] + [Cost] ??

Thanks for response. I can force something, but I don't want to reinvent the
wheel. I guess, that somebody should has the same need before.

 

[Jan De Messemaeker]

Hello Piotr,

Quote: "but I want it to work exactly the same way as Cost etc."
Well, Cost always totals ALL assignments, regardless of what is visible.
So if you want to do it the same way, you have your answer.

As for question 2, that is a matter of VBA syntax.
There are 3 Cost3 fields so it is logical to tell VBA
TheTask.Cost3=Thetask.Cost1+TheTask.Cost2
Or
TheAsgmnt.Cost3=TheAsgmnt.Cost1+TheAsgmnt.Cost2

Which are different formulae altogether.
Yes, you may wonder why a different syntax... but since Project VBA is miuch
older than the formulae, it would have been logical to make the formula look
lmike VBA rather than the reverse )