Skip to main content
Level 2
October 19, 2022
Question

TASK REPORT: Actual Duration is greater than Planned Duration

  • October 19, 2022
  • 2 replies
  • 816 views

This feels like an easy report, but we're struggling to create it. We want to only see tasks where the actual duration was 5 days greater than the actual duration. Essentially this is a task report that would only show tasks that took 5 days more than we planned for. This seemed like an easy one, but I have found it to be challenging. 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

skyehansen
Community Advisor and Adobe Champion
October 19, 2022

I'm not entirely sure that you can perform calculations like this in a filter, so it's probably best to use a calculated field on all your tasks that performs this math before you get to the report, so that your report merely looks for whether this field has the right answer. In other words, your task custom form would have a field on it subtracting actual from planned duration and giving an answer only if the difference is more than 5. Then the report would just filter for the calculated field.

GrahamJarrett
Level 4
October 19, 2022

while you cannot use an expression in the filter when comparing a FIELD, you can group the report into brackets, and have them collapsed so that you just open up the ones you wish to see...

 

In the following group text I created groups for 0 - 5 days, 6 - 10 days, 11 - 25 Days, 26 - 50 Days, 51 - 100 Days and > 100 Days

 

Code is textmode ==>

 

textmode=true
group.0.iscollapsed=true
group.0.valueexpression=IF(DIV(SUB({actualDurationMinutes},{plannedDurationMinutes}),480)<5,"0 - 5 Days",IF(DIV(SUB({actualDurationMinutes},{plannedDurationMinutes}),480)<10,"6 - 10 Days",IF(DIV(SUB({actualDurationMinutes},{plannedDurationMinutes}),480)<25, "11 - 25 Days",IF(DIV(SUB({actualDurationMinutes},{plannedDurationMinutes}),480)<50,"26 - 50 Days", IF(DIV(SUB({actualDurationMinutes},{plannedDurationMinutes}),480)<100,"51 - 100 Days","Over 100 Days")))))
group.0.valueformat=HTML
group.0.linkedname=direct
group.0.name=Duration Timeframe

Doug_Den_Hoed_AtAppStore
Community Advisor
Community Advisor
October 19, 2022

 

Nice one Graham -- thanks for sharing!

 

I liked it, so I Liked it, and it Liked it -- bonus.

 

Regards,

Doug