Text mode help: Calculate issue dates' difference in Assignment report | Community
Skip to main content
ElenaDooley
ElenaDooley
Level 4
February 16, 2022
Solved

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

  • February 16, 2022
  • 2 replies
  • 712 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by 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 replies

imgrund
Adobe Employee
imgrundAdobe EmployeeAccepted solution
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
ElenaDooleyAuthor
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!

Terms & ConditionsAccessibility statement

Loading footer...