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!

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

percent ontime

Status
Not open for further replies.

skootsu

Programmer
Sep 27, 2005
21
US
Help? I got a report nearly complete but I have a percent showing in reverse. I need to show %ONTIME but I am showing the opposite, %LATE. This is the formula on my groups,Sum ({@@Count_Late}, {@@ProductID_Grouper})*100/Count ({CUSTOMER_ORDER.ID}, {@@ProductID_Grouper})
The result is 29%. This is correct for the actual %LATE. I need to show the %ONTIME which would be 71%. Simple math I'm sure, just math? On Monday morning?? Not my strong suit.
Can anyone help me get this reversed? Thanks
 
Try this: put parentheses around your existing formula and add "100 -" to the front of it.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top