I hope you guys will be able to help me. I have a field that takes dates only. In this date field I have set the conditional formatting to turn the field red when more than one day has passed beyond the date entered into the field. Is there a way for me to determine the percentage of time the field goes past the posted date?

I know it sounds a little strange but I am trying to create an analysis report that shows how often project go beyond the completion date entered into the date field.

You help is great appreciated.

Cheers,

Kasei

You will need to define a calculation field for this. Or, if you want a graphical display, a series of objects with conditional formatting (say 10 objects, each highlights at +10%).

---

That is if I understand correctly what you mean by "percentage of time".

Edited June 17, 200916 yr by Guest

It sounds like you want to be able to display the percentage of projects that are currently past their deadline.

You will need to create a calculation field that returns 1 when the deadline is past. This will use the same logic you used for your conditional formatting. Then, create a summary field that totals this and another unstored calculation field that divides the summary by a generic count summary field of all your records.

Feel free to chop apart and use for your solution.

I have attached a how-to file.

Let me know if you have questions, I would love to help. I have definitely gotten stuck on creating percentage summaries.

Regards,

Lauren Kuhlman, Application Developer

Soliant Consulting

FileMaker 10 Certified

FileMaker 9 Certified

http://www.soliantconsulting.com

Connect with me on LinkedIn

http://www.linkedin.com/in/laurenkuhlman

DeadlinePastPercentage.fp7.zip

Edited June 17, 200916 yr by Guest

Well, if that was the question, then it could be much simpler:

DeadlinePastPercentage.fp7.zip

Nice Comment, Comment. I hadn't thought of using Average.

Regards,

Lauren Kuhlman, Application Developer

Soliant Consulting

FileMaker 10 Certified

FileMaker 9 Certified

http://www.soliantconsulting.com

Connect with me on LinkedIn

http://www.linkedin.com/in/laurenkuhlman

Edited June 17, 200916 yr by Guest

Thank you so much for your help. I am implementing what you guys suggested. I will let you know what happens. Sorry for not thanking you right away. FileMaker Pro Advanced 9 stopped working on my PowerBoook G4 this morning. Luckily I have it running on a MacBook. I am still trying to figure out what happened.

Cheers,

Kasei

Well it looks like I may have too much data to handle this setup. I have over 5000 entries going back to 2005.

Any suggestions?

Try removing the unstored calculation field from the layout. You only need the summary field, which can go into the footer or a trailing grand summary part.