C
christopher.k.clark
I'm using the ProjDateDiff function to determine Planned value using
the following formula:
IIf([Baseline Finish]>[Status Date] And [Status Date]>[Baseline
Start],(projDateDiff([Baseline Start],[Status Date])*([Baseline
Work]/ProjDateDiff([Baseline Start],[Baseline Finish])))/60)
However, when the value is returned, it appears to be using the default
project calendar and not the resource calendar who is assigned the
task. The formula is stored in a custom field that is used for all
tasks and all resources, so I can't really hardcode a calendar. It was
my understanding that the function used the project calendar by default
UNLESS there was a resource calendar which would then supersede.
Can anyone help?
the following formula:
IIf([Baseline Finish]>[Status Date] And [Status Date]>[Baseline
Start],(projDateDiff([Baseline Start],[Status Date])*([Baseline
Work]/ProjDateDiff([Baseline Start],[Baseline Finish])))/60)
However, when the value is returned, it appears to be using the default
project calendar and not the resource calendar who is assigned the
task. The formula is stored in a custom field that is used for all
tasks and all resources, so I can't really hardcode a calendar. It was
my understanding that the function used the project calendar by default
UNLESS there was a resource calendar which would then supersede.
Can anyone help?