I am stuck with a formula, or at least I think it can be handled with a formula.

 

What I want to do is remove data from a report if the following condition is true.

 

If The Qty "Received" is at least 90% of the Qty "Ordered" then I don't want to see it on the report.

 

Example:

 

100 widgets ordered

95 widgets received

Condition is satisfied, don't show on report

 

 

100 widgets ordered

80 widgets received

I need to see these lines on the report...It is not 90% or better match...

 

On my report, I do have the two fields to report from - QtyOrdered and QtyReceived - data populates in both depending on the status of the order.

 

Thanks for any help you might have....