Resources, Durations and Planned Hours are Blank for Sub-Task

[meshackOm]

Hi Community, 

I'm trying to create a report to pull sub-tasks with Blank resources, or Durations or Planned hours. The purpose of this report is to ensure project owners or PMs don't leave any sub-task blank during project planning. 

Below (screenshot) is the report I created but is not working as expected, is pulling parent task and sometimes it does NOT pull sub-task that has no resources, or durations or planned hours. 

Any help on what filters to apply will be much appreciated. 

Thanks 

[Ryzan99 · Accepted solution]

Hi. Have you tried including "Task > Number of Children" within both the first and last logic? Since you're using an OR statement, you also need to include the same filter (Task > Number of Children) in the other logic. Please refer to the example screenshot. I hope this solution helps you.

[meshackOm]

Thank you so much @Ryzan99  and @Kundanism , your input was very valuable and it works. Please see the filters I used as per your input. Your help is super appreciated. 

Regards,

Mesh 

[Ryzan99]

You're welcome, @meshackOm.

[Kundanism]

May be you can try this one. Please refer the attachment. Believe matches your requirement criteria.

[meshackOm]

Thanks @Ryzan99 !