Summarize custom column in report | Community
Skip to main content
B
BrittanyB8
Level 3
May 25, 2021
Question

Summarize custom column in report

  • May 25, 2021
  • 1 reply
  • 628 views

I have this custom text in a column that looks at creating a date difference between the actual completion and a custom target launch date. I would like that number to also appear in the summary tab on the report.

Does anyone know what I can add to it?

displayname=Date Difference - Actual

textmode=true

usewidths=true

valueexpression=WEEKDAYDIFF({actualCompletionDate},{DE:PLF - Target Launch Date})

valueformat=HTML

width=75

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

1 reply

SamanthaIsin
SamanthaIsin
Level 7
May 26, 2021

I believe you'll need it in a calculated field built on a custom form that's like this in order for it to display on your summary tab since calculated expressions in view columns can't be used on charts. Here's the documentation I used to come to that conclusion. It doesn't say anything specific about the summary tab, but I'm assuming it's more like the chart than the details in terms of behavior.

https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FReports_and_Dashboards%2FReports%2FCalc_Cstm_Data-Reports%2Fcalculated-custom-fields-calculated-columns.html&_LANG=en

B
BrittanyB8Author
Level 3
May 26, 2021

That is very helpful! thanks

Terms & ConditionsAccessibility statement

Loading footer...