Report filter by calculated field

[kaveman]

I have a report where I want to show quantity A (days on time for work)divided by quantity B (total number of work days) as a percent for every employee at a company. I am able to do this by using a text box and typing in my calculation [quantity_A]/[quantity_B]. Everything works out ok...but now I want to show only those percentages that are under a certain amount. How can I filter the report to exclude any values under a certain percent?

 

[ThreeCrow]

First you should use a underlying Query for your Report. Do your calculations in this Query.

In the last field of the Query your calculation should be

QuantityPercent:[Quantity_A]/[Quantity_B]

In the Criteria Field place (just below this calculation)

<.80
This will show only those records that are less than 80%
<=.80
This will show 80% or less

If you would wish to change the filter percentage (for what ever reason) this will require a Dialog Form.


Hope this Helps

PS: change the control on your report to QuantityPercent

 

[kaveman]

Makes perfect sense. Thanks for the quick reply.