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?
Thanks
Best Answer
-
You would use the same SUMIF statements that you are currently using to get your total for Set and your total for held. Then you would divide set by held. Or maybe held by set is the right way to go to get a percentage. My coffee needs a refill. Haha.
Either way it is simply one SUMIF divided by the other. So just drop in whatever SUMIF you said you were already using to pull the total.
Answers
-
Yes. You would use something along the lines of...
=SUMIF([Appt Set]:[Appt Set], ...............) / SUMIF([Appt]:[Appt Held], .........)
-
Thank you @Paul Newcome! How would I add in only calculating the last 7 days to this formula?
-
You would use the same SUMIF statements that you are currently using to get your total for Set and your total for held. Then you would divide set by held. Or maybe held by set is the right way to go to get a percentage. My coffee needs a refill. Haha.
Either way it is simply one SUMIF divided by the other. So just drop in whatever SUMIF you said you were already using to pull the total.
-
@Paul Newcome, That worked. I tried it before and it did not, so I'm sure it was just a spacing issue! LOL.
Thanks for your help!
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives