OK .
I just responded to your other post so this is making more sense between the two of them.
If you want to go down this path you will need to use Running Totals (RTs) or variable formulas to get your numbers.
I use RTs...
YoOu have agroup on director then a group on department.
try making 2 RTs for each value you want
Name=TargetWeek1
Type of SUmmary=SUM
evaluate=use a formula
{DS_PMR_DOLLARS_AND_HOURS.TIME_FRAME_END_DATE} = 20100206
Reset=on group1 (assuming I had your group set up correct)
Name=ActWrkFTEWeek1
Type of SUmmary=SUM
evaluate=use a formula
{DS_PMR_DOLLARS_AND_HOURS.TIME_FRAME_END_DATE} = 20100206
Reset=on group1 (assuming I had your group set up correct)
Now for week one create your formula as
{#TargetWeek1} % {#ActWrkFTEWeek1}
Place on Group footer1 to see the % for week one.
Repeat process for week 2 but change your evaluate formula in those RTs to use
{DS_PMR_DOLLARS_AND_HOURS.TIME_FRAME_END_DATE} = 20100220
repeat per weeks you want.
Edited by DBlank - 23 Mar 2010 at 9:41am