Need help with a value expression for a report | Adobe Higher Education
Skip to main content
J
JuliaPh1
Level 2
January 31, 2024
해결됨

Need help with a value expression for a report

  • January 31, 2024
  • 1 답변
  • 530 조회

Hello! I currently have a column in an Issue report where the value expression is:

 

valueexpression=IF(ISBLANK({DE:OBO Window Closes}),ADDWEEKDAYS({project}.{plannedCompletionDate},-20),ADDWEEKDAYS({DE:OBO Window Closes},-2))

 

So right now if a custom field called "OBO Window Closes" is blank, this column displays a date that is 20 days prior to the Project Planned Completion Date. I've been asked to change the logic so that if "OBO Window Closes" is blank, this column displays a date that is 45 days prior to "Ship to Wholesalers Begins." This "Ship to Wholesalers Begins" is a date in a column in the report that is pulling the Planned Start Date of a task in the project task list called "Ship to Wholesalers."

 

The rest of the value expression can remain the same.

 

Can someone help me figure out how (or tell me whether it's even possible) to pull the planned start date of a task (or the date from another column) into this calculation?

 

Thank you!

Julia

이 주제는 답변이 닫혔습니다.
최고의 답변: skyehansen

The issue is able to pull the project date because the issue is inside the project. If the issue was inside your task, you'd similarly be able to pull your task date. 

1 답변

skyehansen
Adobe Champion and Community Advisor
skyehansenAdobe Champion and Community Advisor답변
January 31, 2024

The issue is able to pull the project date because the issue is inside the project. If the issue was inside your task, you'd similarly be able to pull your task date. 

약관 및 조건Accessibility statement

Loading footer...