Expand my Community achievements bar.

The first Coffee Break sweepstakes in the Workfront Community is TOMORROW at 8:30AM PST! Share your Project Template and Timeline best practices or ask a related question for an opportunity to win Workfront swag.

Calculated Custom Report Column That Returns a Rate

Avatar

Level 10

Hi WF Community,

We have a custom task form that tracks internal errors.

I'm wondering if anyone knows of a calculated custom column on a report that would accomplish the following?

  • Take the record count for the number of tasks in the report that have a value in the Internal Error Reporting (e.g. 100 task records), and divide it by total number of task records in the report (e.g. 500 task records in total). In this example, the new custom calculated column value would be 20%.

Any suggestions or text mode are welcomed.

Thanks.

Nick

Topics

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

1 Reply

Avatar

Level 6

Not without using the API I'm afraid :-(