Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Calculated Custom Report Column That Returns a Rate

Avatar

Level 9

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