Calcualtions with Conditional Formatting

[Kasei]

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

[comment]

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, 2009 by Guest

[LaurenKuhlman]

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, 2009 by Guest

[comment]

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

DeadlinePastPercentage.fp7.zip

[LaurenKuhlman]

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, 2009 by Guest

[Kasei]

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

[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?

[comment]

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.