Build a report to identify requests that are fully paid and have all follow up forms complete.
-
Build a data set to pull in the appropriate processes, request statuses, and fields.
- Select the Approved and Follow Up Complete statuses.
- Select One Row per Request as the output.
- In addition to any other fields, include the following:
- Contact First and Last Name
- Process Name
- Grant Balance
- Click Run New Report.
- The report will display one row of data for each included request.
- The report will display one row of data for each included request.
- Add a filter to only view requests with a grant balance of 0.
- To do this, filter on the Grant Balance column. Set the Comparison field to "=" and the Value field to "0."
- To do this, filter on the Grant Balance column. Set the Comparison field to "=" and the Value field to "0."
- Click Save New Report.