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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives