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.
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%
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.
Stacy Chamblee: Thank you for this thoughtful information. I will give it a try, and I will let you know how it works.