using a sum of sum in a parameter 1

[DJWheezyWeez]

I'm using CR XI.

I have {table.ReceivedQty}, {table.OrderedQty}, and two formulas for percentages:

{table.ReceivedQty}/{table.OrderedQty}*100

and

Sum ({table.ReceivedQty}, {table.Job})/Sum ({table.OrderedQty}, {table.Job})*100

The formula {@ Complete} is in the details section giving me percentages of each line. The formula {@ Complete Total} adds up the quantities' totals (not the percentages) and gives me a percentage for them.

What I'm trying to do is be able to put in a parameter to be able to restrict the report by the percentage given by {@ Complete Total}. Problem I'm having is that it won't show up in the Select Expert for me to do this. Is this possible or is there another work around?

-DJWW

 

[lbass]

Go to report->selection formula->GROUP and enter:

Sum ({table.ReceivedQty}, {table.Job}) % Sum ({table.OrderedQty}, {table.Job}) < {?Parm}

Not sure how you wanted to limit the report, so adjust the sign as necessary.

-LB