Active Task(s) on Project Level Report - Pulling in CNC tasks!

[mvsteep]

Hi Everyone! 

We started testing out a new project level report that could show stakeholders what current task is being worked on. We leveraged the below:

displayname=Current Task

listdelimiter=<p>

listmethod=nested(tasks).lists

type=iterate

usewidth=true

valueexpression=IF({canStart}=true && {status}!='CPL' && {numberOfChildren}=0,CONCAT("•",{name}))

valueformat=HTML

width=100

All was well until we realized it was also pulling in canceled tasks. Any suggestions on how to tweak the expression?

[AbiRains]

Hi, I think if you update your value expression to include the below it should filter out those cancelled tasks. You'll probably want to double check that 'CAN' = cancelled under your setup > project preferences > statuses > tasks. Hopefully this helps!

valueexpression=IF({canStart}=true && {status}!='CPL' && {status}!='CAN' && {numberOfChildren}=0,CONCAT("•",{name}))

[KellieGardner · Accepted solution]

You would also need to add a statement for your other status. 

valueexpression=IF({canStart}=true && {status}!='CPL' && {status}!='CNC" && {numberOfChildren}=0,CONCAT("•",{name}))

[kautuk_sahni]

@mvsteep Just checking in — were you able to resolve your issue? We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!