Text mode help: Calculate issue dates' difference in Assignment report | Adobe Higher Education
Skip to main content
ElenaDooley
Level 4
February 16, 2022
해결됨

Text mode help: Calculate issue dates' difference in Assignment report

  • February 16, 2022
  • 2 답변들
  • 721 조회

I would love a text mode expert's help. I am trying to display in the View of an Assignment report the duration in weekdays from Entry Date to Actual Start Date. I'm wondering if it's an object type discrepancy... do I need to add in a reference to the "issue" object type in the code because it's an Assignment report vs. an Issue report? I've tried about a dozen different things just by researching Workfront One documentation and discussions. The two that I thought would work are these If anyone wants to take a look and offer suggestions, much appreciated!

displayname=Response Time

textmode=true

valueexpression=WEEKDAYDIFF({entryDate},{actualStartDate})

valueformat=HTML

-or-

displayname=Response Time

linkedname=direct

querysort=entryDate

textmode=true

valueexpression=ROUND(WEEKDAYDIFF({entryDate},{actualStartDate}),2)

valueformat=HTML

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

Hi - because an assignment object type is tied to a few object types, you have to reference them in your calculation:

displayname=Response Time

textmode=true

valueexpression=WEEKDAYDIFF({opTask}.{entryDate},{opTask}.{actualStartDate})

valueformat=HTML

2 답변

imgrund
Adobe Employee
imgrundAdobe Employee답변
Adobe Employee
February 16, 2022

Hi - because an assignment object type is tied to a few object types, you have to reference them in your calculation:

displayname=Response Time

textmode=true

valueexpression=WEEKDAYDIFF({opTask}.{entryDate},{opTask}.{actualStartDate})

valueformat=HTML

ElenaDooley
ElenaDooley작성자
Level 4
February 16, 2022

Woo hoo! You know, I tried opTask on other attempts but didn't have the brackets and periods right. Thanks, Anthony!