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?