Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

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

Avatar

Level 5

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

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

Avatar

Correct answer by
Level 10

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

Avatar

Level 5

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