
1. Re: Calculating FROM 100% DOWN rather than UP TO 100%
SteveMartino Jul 23, 2015 6:54 AM (in response to maxmorley@verizon.net)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%
schamblee Jul 23, 2015 2:18 PM (in response to maxmorley@verizon.net)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%
schamblee Jul 23, 2015 2:17 PM (in response to maxmorley@verizon.net)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%
maxmorley@verizon.net Jul 24, 2015 6:53 AM (in response to maxmorley@verizon.net)Stacy Chamblee: Thank you for this thoughtful information. I will give it a try, and I will let you know how it works.