Text mode to only show fields where the Tasks parentID = spaces/isnull

[DaBell]

How can I wrap an IF statement around the below, where I only show fields where the Tasks parentID = spaces/isnull?

displayname=TEST - Active Stages
listdelimiter=<div>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF(ISBLANK({DE:Stage - Task Level}),"",{DE:Stage - Task Level})
valueformat=HTML

Basically, I only want to show {DE:Stage - Task Level} for the Parent Tasks.

Thanks in advance!

[Madalyn_Destafney]

Trying to understand your goal. You want to see incomplete parent tasks? If so, you can add a filter to your task report for ‘task > number of children’ greater than 0, to only pull parent tasks, and filter for percent complete greater then 0% complete. 

[DaBell]

Thanks for the reply.

This is a Project-based report.

There are multiple Parent Tasks nested in my Projects.  So, I can't look at the number of children.  I only want to display the top Parent, this is why I want to only get the Parent Task that does NOT have a parentID.

...and then display this custom field:

{DE:Stage - Task Level}

That is why I would like to wrap an IF statement that checks IF parentID = spaces/isnull?

I'm just not sure on that syntax.

[Heather_Kulbacki · Accepted solution]

@DaBell 

I'd probably do a nested IF statement that first looks for tasks that don't have a parent (parent ID is blank), then from those tasks look for tasks that do have child tasks (number of childer > 0), once you've found those tasks just show what's in your "Stage - Task Level" field

IF(ISBLANK({parentID}),IF({numberOfChildren}>0,{DE:Stage - Task Level}," "))

If you don't have any stray tasks that aren't under a parent at the bottom of your task list, you could skip the part about looking for tasks that do have children.

valueexpression=IF(ISBLANK({parentID}),{DE:Stage - Task Level}," ")

[DaBell]

Thank you!