IIF in formula

[Theo]

Hi,

I need some advise on a Project formula. I have created two colums to show
costs for resources, either internal resources or external resources. I have
created two resource group types and assigned resources to either group. I
then created the following formula to only calculate and display resources
assigned to the task from either group.

IIf([Resource Group]="External",[Cost],0)

The formula works fine if you only have resources from a single Group
assigned to a resource. The problem with this formula is that if you assign
resources from different groups (one from internal and one from external) to
the same task the formula only shows 0.

Any suggestions? I need to just be able to loop through the resources
assigned to a task and use the cost from a group to determine the resource
cost for a task.

 

[Jan De Messemaeker]

Hi Theo,

You won't be able to do this with a formula. What you can do:
- Write a vba procedure walking through "For each assignment" and toitaling
it into two task custom fields
Or go to the resource usage view, Project, group by, More groups, select the
line "Group" click Edit
As field type select assignment and check Group assignments, not resoruces.
Applyoing thos grouping wuill give yyou the figure you need, be it in a
group then Task order.
Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf