Summarize durations by month?
Hi everyone:
I'm looking to do some duration reporting and I'm not sure that it's possible. I have a formula-duration field that calculates the difference (in days) between two dates. That part works great. But the folks I am working with would like that information to be summarized by month - so they could get a count of things that took less than one month, less than two months, longer than two months, etc.
Is something like this possible?
And, for extra credit - there are items that have no duration, marked "LTF" in another field. They would also like those totaled. So the results would be something like:
>1 month 12
>2 months 34
LTF 85
Doable? Partly doable? Let me know what you think, and thanks so much for any help you can provide.
Suzanne
I'm looking to do some duration reporting and I'm not sure that it's possible. I have a formula-duration field that calculates the difference (in days) between two dates. That part works great. But the folks I am working with would like that information to be summarized by month - so they could get a count of things that took less than one month, less than two months, longer than two months, etc.
Is something like this possible?
And, for extra credit - there are items that have no duration, marked "LTF" in another field. They would also like those totaled. So the results would be something like:
>1 month 12
>2 months 34
LTF 85
Doable? Partly doable? Let me know what you think, and thanks so much for any help you can provide.
Suzanne
