Calculating Percentage on Report

What is the quickest way to calculate the percentage difference between two fields on a report?

txtHolidaysHoliday = 80

txtHolidayHoursPayAvailable = 87.30

The record has 7.30 hours extra holiday pay available over what they can take, but how to I find out the percentage over excess holiday hours and put it in the control source of txtPercentageExcessHolidays

gcgcitAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
try

=format((txtHolidayHoursPayAvailable - txtHolidaysHoliday)/ txtHolidaysHoliday,"percent")
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.