Percentage of complete

  • Thread starter Thread starter Toni
  • Start date Start date
T

Toni

I need the formula to use for finding the percentage of work completed. I
need to divide ([Installed Direct Hrs Earned]/[Est Man Hrs])*100 in this
calculation I get the percentage answer of 41000.00% using
SumOfEst Man Hrs SumOfInstalled Direct Hrs Earned
926.34 95.33
The answer in Excel is 10.29% What am I doing incorrect? 95.33/926.34

Thanks in advance
 
format(95/926,"percent") = 10.26%
be sure to reference the full name of the query field, ie, [sumofest man
hrs], not just the [est man hrs] field or you'll get just the last record
detail.
 
That is strange. If you are doing this with a query, show us the SQL. Open
the query in design view. Next go to View, SQL View and copy and past it here.
 
Back
Top