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.
Haven’t done this before personally, but I did a little SuiteAnswers searching for you. Based on “Sales Orders Pending Fulfillment Report > Show total count of Orders per Target Ship Date” SuiteAnswer Id: 62147, it looks like they’re suggesting to create a numeric custom field and then use that. I can’t think of any other way I would meet the requirement since Internal and External IDs don’t seem to be available.
Thanks!
