Search results for query: *

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...

This is what I have in my @BAC formula: IF {Virtual RRM.rrmValueType} = 'S' THEN {Virtual RRM.rrmTDlrs} ELSE 0 The above formula is used to report baseline information.

I have a similar problem. I am trying to calculate % complete. and used the above formula...however, I get a zero result. Here is my formula: If not(isnull({@BAC})) and {@BAC} <> 0 then {@BCWP}/{@BAC} else 0 The funny thing is that when I run my report...I have zero values for @BAC in some...

Thanks Dale! The solution you provided worked perfectly. For anyone that might have a similar problem, here's how Dale solved it: 1) Created a &quot;length&quot; formula to determine the length of the number. 2) Created several &quot;pos_x&quot; formulas for proper position and formatting...

Another method: 1) Select the cells you want to split. 2) Under Data, click on &quot;Text to Columns...&quot; 3) Check &quot;Fixed Width&quot; 4) Create a &quot;break line&quot; between the data shown - a vertical line should appear which signifies a break in data. 5) Click Finish and you will...

Wonder if the following is possible in Excel: Let's say I have the following numbers (which are generated when I export from an internal query s/w program, Brio, into Excel): 1 101 10102 10103 1010301 1010302 102 I would like to be able to automatically convert each of the above to the...