Hi friends,
Having a bit of difficulty setting up a series of over/under reports. I'd like the report to pull any project with the employee's name matched in the "Resource name", and only pull projects where the "Resource status" is set to "Active" (or "not Inactive" to pull anything where we may have made an error). This is all well and fine except for when I try to also include one row where there is no resource name to pull - primary column is equal to "Maximum allocation per month". This is a row that will never have a resource assigned but instead will be used across everyone's individual reports. Hopefully that makes sense.
How can I convince the report builder to include this row while still only include "active" projects assigned to the "resource name", and have this work across each individual per-person report? I've tried every combination of "and" and "or" to no avail.
Any tips/tricks? Screenshots below. Thanks!
