4 Replies Latest reply on Jul 24, 2015 6:53 AM by maxmorley@verizon.net

# Calculating FROM 100% DOWN rather than UP TO 100%

### Title

Calculating FROM 100% DOWN rather than UP TO 100%

### Post

I keep attendance for my Rotary Club. In the attached graphic, the field on the right is calculating percentage of attended meetings as the weeks pass by. James K. Adams would reach 100% when and if he attends all meetings through September 24.

I would like for the calculation to say that the Rotarian’s attendance is at 100% until he/she misses – thus calculating FROM 100% DOWN rather than UP TO 100% as it is presently doing.

In this graphic, I want Adams, Benedict, and Biggerstaff to show 100% as of July 16. The percentage will drop if they miss a meeting along the way. Abbott would show 66%.  Aldridge and Alvarado would show 33%, etc.

Can you tell me how to accomplish this task?  Thank you so much.

• ###### 1. Re: Calculating FROM 100% DOWN rather than UP TO 100%

Is this the actual layout in FM?

Can you show this in Layout mode?

What's the current script to calculate percentage that you are using.

• ###### 2. Re: Calculating FROM 100% DOWN rather than UP TO 100%

First of all your calculation in your chart is incorrect. 2 dates out of 13 is not 20%.  2 items out of 13 is 15% .

Example : You have 13 dates, if attended 13 dates then it would be 100%

da= days attended,  td= total possible days

da/td*100= %    13/13*100=100% , 2/13*100=15%, 6.5/13*100=50%

• ###### 3. Re: Calculating FROM 100% DOWN rather than UP TO 100%

You have more than one calculation you need to compute.   You will have select the cut off date which is July 16 in your example. You will then need to compute the number of missed meetings between the start and the cut off date.  You will need to calculate the % rate for each day which would be 1/13*100 = 7.69%.  You would then take the daily rate and multiply that by the number of missed days. 1 * 7.69% = 7.69%.   Your final calculation would be 100%-missedday%  (100%-7.69%) which would give you  92% for Abbott in your above example.

Sorry for post and repost, got busy.

• ###### 4. Re: Calculating FROM 100% DOWN rather than UP TO 100%

Stacy Chamblee: Thank you for this thoughtful information.  I will give it a try, and I will let you know how it works.