Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

Group by actualCompletionDate and plannedCompletionDate

Avatar

Level 1

Hi,

 

I want to group a report by those projects that were closed before/same and after reaching their plannedCompletionDate.

 

I believe I can achieve this with text mode, but I dont know how to do it for groupings. Any help will be truly appreciated.

 

BR,

 

Edgar

1 Reply

Avatar

Employee Advisor

I'm not sure I fully understand your ask, but I'm hoping this may do the trick. The text mode below says if the actual completion date is past the planned completion date, display "Late", otherwise, display "On Time."

You can customize the Late/On Time terminology, but it should give you a framework to start with. Likewise with the displayname= line, you can customize what comes after the = sign. 

 

group.0.displayname=Project Late vs On Time
group.0.valueexpression=IF({actualCompletionDate}>{plannedCompletionDate},"Late","On Time")
group.0.valueformat=HTML
textmode=true