I am trying to create two separate straight tables; one showing projects started this month and the second showing projects completed this month. The way I would like to determine this is through the fields EPIC_STATUS, EPIC_START_DATE, EPIC_SUMMARY, PROJECT_NAME, and EPIC_DUE_DATE.
For projects that started in this month I figured the epic_start_date would be the filed to reference. A written statement would be as follows:
If(EPIC_START_DATE = current month and EPIC_STATUS -= NOT REQUIRED and PROJECT_NAME -= PMO IMS PIPELINE, then EPIC_SUMMARY).
For projects that are completed in this month I figured the epic_due_date or epic_status would be the field to reference. A written statement would be as follows: If(EPIC_DUE_DATE = current month and EPIC_STATUS -= NOT REQUIRED and EPIC_STATUS = DONE, and PROJECT_NAME -= PMO IMS PIPELINE, EPIC_SUMMARY).
Now I know know I used and if statement but if this doesn't work and some set analysis would I will use that instead.
I would like to make this Dynamic too, so as the months go by it will auto correct itself to the current month.