Calculated Custom Report Column That Returns a Rate | Community
Skip to main content
Level 9
September 23, 2020
Question

Calculated Custom Report Column That Returns a Rate

  • September 23, 2020
  • 1 reply
  • 508 views

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

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

1 reply

ChrisBudgen
Level 5
October 7, 2020

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