Hi,

I am trying to count the Total Percentage of Delivery Quantities that are within 2.00% of the relivant Ordered Quantities (there is one match for each record).
Would the following Formula count ONLY those records that fall within this margin (2%) ....OR would it count ALL the Delivered Quantity records?

If(({Test_txt.OrderedQuantity})/({Test_txt.DeliveredQuantity}))*100 >= 98.00
Then
Count({Test_txt.DeliveredQuantity}) & "%"

Perhaps there is a better method? Please can anyone help????

Thanks in advance,


Neal

A Northern Soul

__________________
Neal

A Northern Soul