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.

Beginner Asked on January 14, 2020 in Reports.
Add Comment
1 Answer(s)

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.

 

Beginner Answered on January 15, 2020.

Thanks!

on January 15, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.