Formula Editor/SQL (1 Viewer)

[DerbyNeal]

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

 

[Lynn_AccessUser]

I think you mean to do the following (if not, I apologize):

Create a formula for example called

Margin = (Test_txt.DeliveredQuantity/Test_txt.OrderedQuantity) * 100

You want to switch delivered and ordered around from what you did if you are trying to figure out the percentage delivered compared to ordered.

Add this formula field to the detail section of your report. If you don't want to see the field in your report detail then just suppress it.

Now insert a running total on the field using the count summary. On evaluate use the following formula:

{@Margin} >= 98

Be careful where you place the running total because the number it returns is dependent on where the field is placed in your report. I put mine in the report footer.