Group by actualCompletionDate and plannedCompletionDate | Community
Skip to main content
E
EdgarMa2
November 20, 2023
Question

Group by actualCompletionDate and plannedCompletionDate

  • November 20, 2023
  • 1 reply
  • 369 views

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

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

1 reply

NicholeVargas
Adobe Employee
NicholeVargasAdobe Employee
Adobe Employee
December 18, 2023

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

 

Terms & ConditionsAccessibility statement

Loading footer...