Stop while iterating tasks in a report

Question

Hello,

I'm building a project report and need to display the latest task with the percentage equals to 100%. I'm iterating over tasks however the challenge that I am having is that this method is concatenating all the tasks with percentage equals 100% but what is needed is the name of the last one only.

I need a way to wipe the text and keep only the last task with. This is the "code" I have so far:

displayname=Last stage/task completed
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({percentComplete}=100,{name})
valueformat=html

Appreciate any help 🙂

skyehansen · Accepted Answer

hi, it's not clear to me how you NORMALLY go about identifying a last task. i.e. For the most part, everything I put into a valueexpression line is more or less something I would be able to do very simply from a task report. So a good rule of thumb for me is first to ask myself, "self, if you were to run a task report and filter for the last task, what filter would you use to find it?" -- do you have any thoughts here?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded