Used SUMIF and Division in one Summary Field

I have used the SUMIF with TODAY to sum the last seven days of a column and that works great. Now I want to calculate a simple percentage of 2 columns for the last seven days. So if I have a column that has a count of "Appt Set" and a count of "Appt Held" each day, I want an ongoing calculation (I never have to update) that gives me a percentage of appointments held for the last 7 days. Can that be done in one Summary field so I can add it to a Dashboard? If so, what is that formula? Is there a better way to do this?


Best Answer