C
Cindy
I seem to be having a (blonde, senior, stupid - take your pick)
moment...but...I can't figure out how to handle this formula.
We are in need of 3 different number fields with the following
criteria:
1. Task weight - PM sets this at the lowest level task - each summary
task at outline level 3 must equal 100
2. Milestone Weight - this is to be set at outline level 3 only
3. WP Weight - At outline level 2 this should be the sum of all
outline level 3 entries below it (note: there could be multiple
outline level 2 tasks in each schedule).
My problem is number 3 I currently have the following formula for the
field IIf([Outline Level]=3,[Number2],0) - this is setting the field
correctly on outline level 3...but...how to I add up the values to the
parent level 2. I tried this (don't laugh..) IIf([Outline Level]=3,
[Number2],IIf( [Outline Level] =2, sum[Milestone Weight] , 0 ) ) but
of course it didn't work.
Any ideas would be very much appreciated!!
....Cindy
moment...but...I can't figure out how to handle this formula.
We are in need of 3 different number fields with the following
criteria:
1. Task weight - PM sets this at the lowest level task - each summary
task at outline level 3 must equal 100
2. Milestone Weight - this is to be set at outline level 3 only
3. WP Weight - At outline level 2 this should be the sum of all
outline level 3 entries below it (note: there could be multiple
outline level 2 tasks in each schedule).
My problem is number 3 I currently have the following formula for the
field IIf([Outline Level]=3,[Number2],0) - this is setting the field
correctly on outline level 3...but...how to I add up the values to the
parent level 2. I tried this (don't laugh..) IIf([Outline Level]=3,
[Number2],IIf( [Outline Level] =2, sum[Milestone Weight] , 0 ) ) but
of course it didn't work.
Any ideas would be very much appreciated!!
....Cindy