Forum Discussion
ralphobarly
Oct 21, 2022Copper Contributor
Quarterly Report
Hey All, I'm trying to create a function that will allow me to create some quarterly reports. I'm currently attempting to create a custom field with a function that will report whether that task...
John-project
Oct 21, 2022Silver Contributor
Project already has a Date Range filter. Try that, no need to re-invent the wheel (unless it's the wrong size wheel).
John
- ralphobarlyOct 21, 2022Copper ContributorThanks. I think I know what you're talking about. Are you referencing using if date greater than, and, less than, in custom filter settings? I just tried that, and it seems to work. Thanks! I've filtered the tasks and my report is reporting each task cost individually. Is there an easy way for it to report the sum of that filter? Thanks so much again!
- John-projectOct 21, 2022Silver Contributor
One way to show summed up cost is to set a Flag field (e.g. Flag1) for all non-summary tasks in your plan. Apply the Date Range filter and then group on the Flag field. The group summary will show the summed up cost for the filtered tasks.
John