B
Barb PMO
My company uses Project Pro 2003 and Project Server
Thanks for yesterdays help on how to get a formula to multiply Baseline Work
* Project Sale Price to return the Baseline Hourly Rate. That works perfectly
now (Thanks, Marc Soester!)
Now, I need to use an Iif function to evaluate a project flag (Canadian or
US dollar contract) and if Canadian, multiply the result by the exchange
factor. Here's the formula I entered:
IIf([Enterprise Project Flag1]="Yes",([Enterprise Project Cost1]/[Baseline
Work]*60)*1.145,([Enterprise Project Cost1]/[Baseline Work])*60)
The dialog box accepts the formula, but the Canadian projects are still
showing the USD hourly rate, even though I have set the flag on those
projects to Yes.
Any ideas?
Thanks for yesterdays help on how to get a formula to multiply Baseline Work
* Project Sale Price to return the Baseline Hourly Rate. That works perfectly
now (Thanks, Marc Soester!)
Now, I need to use an Iif function to evaluate a project flag (Canadian or
US dollar contract) and if Canadian, multiply the result by the exchange
factor. Here's the formula I entered:
IIf([Enterprise Project Flag1]="Yes",([Enterprise Project Cost1]/[Baseline
Work]*60)*1.145,([Enterprise Project Cost1]/[Baseline Work])*60)
The dialog box accepts the formula, but the Canadian projects are still
showing the USD hourly rate, even though I have set the flag on those
projects to Yes.
Any ideas?