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
2 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

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 and y are the same, this will work*

Rookie Answered on February 10, 2020.

Thank you. This worked!

on February 17, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor