Is there text mode to get the sum of a calculated date difference in a Task Report? (Updated with text mode solution!) | Community
Skip to main content
H
HeatherLa2
Level 3
February 26, 2021
Question

Is there text mode to get the sum of a calculated date difference in a Task Report? (Updated with text mode solution!)

  • February 26, 2021
  • 1 reply
  • 594 views

I currently have a calculated field on a task custom form that shows me the number of days between the handoff and the actual completion date. I'm looking to get the sum of those days to show up in a Task Report, grouped by Project.

I've put my calculated field into a column, and this is the text mode:

displayname=Difference between Handoff and Actual Completion

linkedname=direct

namekey=Weekday Difference between Handoff and Actual Completion

querysort=DE:Weekday Difference between Handoff and Actual Completion

textmode=true

valuefield=Weekday Difference between Handoff and Actual Completion

valueformat=customDataLabelsAsString

Could I use some sort of aggregator text mode in this column to bring in the sum in the Project grouping? At some point, I will also want to look at the average, but for now the sum will be perfect for what I need.

Thank you!

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

1 reply

H
HeatherLa2Author
Level 3
March 1, 2021

I figured it out, so here is the text mode in case anyone would like it:

aggregator.displayformat=compound

aggregator.function=SUM

aggregator.namekey=Weekday Difference between Handoff and Actual Completion

aggregator.valuefield=Weekday Difference between Handoff and Actual Completion

aggregator.valueformat=customDataLabelsAsString

displayname=Difference between Handoff and Actual Completion

linkedname=direct

namekey=Weekday Difference between Handoff and Actual Completion

querysort=DE:Weekday Difference between Handoff and Actual Completion

textmode=true

valuefield=Weekday Difference between Handoff and Actual Completion

valueformat=customDataLabelsAsString

Weekday Difference between Handoff and Actual Completion = my calculated field name on my task custom form. You would replace this with your own field name if you use this! You would also change the dsiplayname to be whatever you want the column to be called.

Hope this helps!

Terms & ConditionsAccessibility statement

Loading footer...