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 wor...
Forum Discussion
Sounds like you just need a formula field to calculate the Duration Bucketing. Then just make a summary report on that field.
IF(
[Other field]="LTF", "LTF",
[Project Duration] < Days(30), "< 30 days",
[Project Duration] < Days(60), "30 to 60 days",
[Project Duration] >= Days(60), "60 days +")
You will need to fiddle with adding extra spaces in the text result to get them to sort correctly.
IF(
[Other field]="LTF", "LTF",
[Project Duration] < Days(30), "< 30 days",
[Project Duration] < Days(60), "30 to 60 days",
[Project Duration] >= Days(60), "60 days +")
You will need to fiddle with adding extra spaces in the text result to get them to sort correctly.