Custom Cost Columns for FY

[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 totals and rollup
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...

I know using the Task Usage View and seting the Cost details and timescale
to months it shows breakout of info I'm looking for each month but not to FY
year.

Or is there a better way. Is there a VBA or Macro that can accomplish this?

Steve

 

[Jan De Messemaeker]

Hi,

There are lots of ways to achieve this

- In a usage view show Yers as minor scalen, and in Tools, Options, Calendar
set Fiscal year to start in October
- In a usage view with the minor scale set to months, show the cummatlve
cost loine; then one subtraction is enough to have the year value
- Or indeed look up the timescaledata method in VBA.

Hope this helps,

 

[Steve]

Jan,

Can you point me in the right direct to look up the timescaledata method in
VBA. I've never deal with this before.

Thanks

Steve

 

[Jan De Messemaeker]

Hi,

In VB Editor (Alt+F11 or Tolols, Macro, VB Editor) you have a button called
object browser.
Once you know this button, consider yourself a VBA guru.
Click it and you can lookup the help of any object, method, function,
property, of all referenced libraries
(You reference a library through Tools, References)
So in the search window type timescaledata.
It gives you several pages of help and examples.
Hope this helps,