Recent content by mattalin

Yes, that is correct. Sorry if I wasn't as specific before.

The formulas for @BAC and @BCWP: @BAC = IF {Virtual RRM.rrmValueType} = 'S' THEN {Virtual RRM.rrmTDlrs} ELSE 0 @BCWP = IF {Virtual RRM.rrmYm} <={?ReportMonth} AND {Virtual RRM.rrmValueType} = 'P' THEN {Virtual RRM.rrmTDlrs} ELSE 0 ...are located in the details field. In the group (WBS) footer...

Disregard my last post - I got it to work using running totals...I just had the setting wrong for &quot;Reset on change of group&quot; Thanks for your help everyone!

FV Trainer, No, I do not have one record per group. I am extracting data for a given month for the BCWP (it's cumulative to date) and the BAC basically sums all the data per group to give me total budget. midearth, The running total method almost did the trick...I am getting data, however...

My formula for @BAC is: IF {Virtual RRM.rrmValueType} = 'S' THEN {Virtual RRM.rrmTDlrs} ELSE 0 my formula for @BCWP is: IF {Virtual RRM.rrmYm} <={?ReportMonth} AND {Virtual RRM.rrmValueType} = 'P' THEN {Virtual RRM.rrmTDlrs} ELSE 0 It calculates them correctly in the report but when I try...

You could try something like this: if termination date > 0 then &quot;T&quot; else &quot;A&quot;

Thanks, this helps but it also gives me another idea on how to solve my problem more generically. I can have CR determine the period (months/weeks) actuals were incurred and simply divide by the total hours/dollars incurred.

Now all I am getting is 0 or 100. Here is my data (located in the grouped task footer): @BCWP for task x = $10,592 @BAC for task x = $13,948 @test (formula trying to make) is showing &quot;100.000000&quot; Answer should be 75.939203

Here's an example of what I am trying to do: Task Month1,Month2,Month3,Month4,%Comp,Run Rate 1 100,100,100,100,50%,100 2 0,0,100,100,50%,100 3 100,150,200,250,75%,175 4 100,100,0,0,100%,100 5 0,100,0,0,100%,100 Run Rate Formula: Task 1=sum(Month1:Month4)/4 = 100 Task...

Now it tells me a boolean is required between the If and totext(isnull({@BAC}))

I get the following error when I use this formula: &quot;A number or currency amount is required here&quot; - looks like it is looking for something after 'else'

I would like to create a formula that will calculate a runrate, hours for example for a given number of periods. My current page will show the manager what the previous month's data was as well as what is scheduled for the current month per task. What I would like to add is a column called...

I currently have it in the task group header. I tried to place it in the footer but same result.

I do have the format set at %. I also tried your formula suggestion but still get zeros throughout.

pgtek, I don't seem to have a problem with @BAC, it extracts the correct data...the problem I am having is when creating a % complete formula using @BAC as the denominator: If not(isnull({@BAC})) and {@BAC} <> 0 then {@BCWP}/{@BAC} else 0 It took care of the divide by zero error but now all...