Hello. I have a query with the fields estimated hours and actual hours. I need to know if we have reached 80% of our estimated hours, so I use
>=0.8*
![EstimatedHours]. This will show me if we've used 80% of our actual hours. Is there a way to maybe add a calculated field to show the true % of hours used, possible name the field "PercentComplete" and it calculate the % between estimated hours/Actual hours, but only display it in the field "PercentComplete" if it is above 80%? Like, could I get it to display the exact % = to or above 80%?
>=0.8*
