RE: How to Get Record Count on Report
Does anyone know a way to get a record count per grouping on a custom report? On a saved search it’s easy. You just need to find a unique identifier like Document Number and do a count summary on it. But reports will only let you do a count summary if it’s a numeric field type, and I need to display the number of records that appear under each grouping.
This is possible using a formula field:
1. Customize Report
2. Navigate to Edit Columns tab
3. Click Add Formula Field
4. Give a name under Column Label
5. Check Add Grand Total box
6. Select Ratio x/y from Formula Type
7. Select Qty from x
8. Select Qty from y
9. Uncheck Apply Formula to Grand Total box
*Logic: You are trying to make your calculation equal 1 per line so that the sum equals the count of lines in the report. If your selection for x and y are the same, this will work*
Thank you. This worked!
