Crystal Reports Creating a report with two queries

Message

   I am trying to create a report that will report the scrap generated accross a number of machines. This is easy enough
but I also want to add to the same report a result that looks at other machines and gathers the total Good qty 

I have a table that has MAchine number, qood qty, scrap qty, run date & time and a number of other values.

What I want the report to show is :

SCRAP CREATED BY  MACHINE 502,505,510,547,727
GOOD QTY FROM machine 502,505,510,547
the table contains information about 70+ machines

This is an extract from the record selection part of the report
{wireact.wcnt_nbr}= ["502","505","510","547","727"] and {wireact.crtd_date} > DateAdd ("h",-24, DateTime (CurrentDate, Time (06,00,00)))

I have a formula that adds different types of scrap together to give me the total scrap 
{wireact.scrp_setup}+{wireact.scrp_ip}+{wireact.scrp_cut}

I have a percentage forumula that gives me the percentage of scrap
(Sum ({@totalscrap})/Sum ({wireact.good_qty}))*100

I want to be able to do the Percentage sum based on the goodqty from only  machines  502,505,510 &547 leaving out the qty from 727.

Is this possible???

I hope everyone can follow my ramblings

Thanks