Cost columns customed for FY periods

[Steve]

I have msp07. I have a project that spans 5 years. Is it possible to
create a custom cost field that is tailored to show the rolled up totals for
only the tasks within a 12 month period, i.e. 1 Oct - 30 Sep... So you
would have a Cost table showing such as Cost, FYCost07, FYCost08, FYCost09,
etc...
Or is there a better way.

Steve

 

[John]

I have msp07. I have a project that spans 5 years. Is it possible to
create a custom cost field that is tailored to show the rolled up totals for
only the tasks within a 12 month period, i.e. 1 Oct - 30 Sep... So you
would have a Cost table showing such as Cost, FYCost07, FYCost08, FYCost09,
etc...
Or is there a better way.

Steve

Steve,
Is it possible, sure. However to do it you need some VBA to capture the
fiscal year timescaled data, roll it up and stick it in 5 separate spare
cost fields. My mind is a little tired, but as far as I can tell, you
cannot do this with grouping and you cannot do this with formulas in a
custom field.

John
Project MVP

 

[Steve]

John,

Can you point me in the right direction to create something that might work?

Steve

 

[John]

John,

Can you point me in the right direction to create something that might work?

Steve

Steve,
Unfortunately I do not have the time to develop the code for this right
now. However, you might try posting to our sister newsgroup,
microsoft.public.project.developer and see if someone there can help you
out in the near term.

John
Project MVP

 

[Steve]

John, thank you, that's what i have done.
Steve

Steve,
Unfortunately I do not have the time to develop the code for this right
now. However, you might try posting to our sister newsgroup,
microsoft.public.project.developer and see if someone there can help you
out in the near term.

John
Project MVP

 

[John]

John, thank you, that's what i have done.
Steve

Steve,
You're welcome. Sorry I bounced you around. That's what happens when my
eyelids are drooping (brain almost totally shut off) and I answer a post.

John