Good afternoon, My group uses a project report to keep track of the milestones and tollgates of our product launches. One particular report has numerous columns that are populated by a collection (tasks) and a valueexpression to pick out just a particular milestone plannedCompletionDate. Something l...

Apparently, I just needed to talk it through, and I was overcomplicating it. Ended up doing this: displayname=Variance (Business Days) textmode=true valueexpression=WEEKDAYDIFF({DE:Due Date Deadline},{actualCompletionDate}) valueformat=HTML Corey Beavers Mohawk Industries, Inc.

Current Textmode that isn't working: displayname=Variance textmode=true valueexpression=CONCAT(ROUND(DATEDIFF({Actual Completion Date},{DE:Due Date Deadline}),1),""," days") valueformat=HTML Corey Beavers Mohawk Industries, Inc.

Good afternoon! We have a custom form, connected to a queue, through which users submit requests to our Creative group. One of the required fields a requester would fill in on that form is a DATE field called "Due Date Deadline". Making use of that field, I'd like to produce a report that returns 4 ...