Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mattalin

  1. mattalin

    Division by Zero

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

    Division by Zero

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

    Division by Zero

    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!
  4. mattalin

    Division by Zero

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

    Division by Zero

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

    Changing a Date to a Letter

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

    Hour Run rate by month

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

    Division by Zero

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

    Hour Run rate by month

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

    Division by Zero

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

    Division by Zero

    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'
  12. mattalin

    Hour Run rate by month

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

    Division by Zero

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

    Division by Zero

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

    Division by Zero

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

Part and Inventory Search

Back
Top