List report with SUM (based on grouping)

[richofing]

I want to create a report that lists all our assets, grouped by class, along with a total of the cost of the assets in the group. The screen shot below shows an example of an asset report, grouped by class. I would like to be able to see the total cost of the three vehicle assets displayed on the report.

Ric

[Patrick Schult2]

Use one of the aggregating chart types - bar/pie, for example. You can also ticket the Display Grid checkbox if you want to see a list output in addition to the graph.

Type: bar or pie

Group by: Class and Sum by Cost.

Aggregation: SUM, Cost

[Dennis R]

Yeah, ServiceNow doesn't support (that I know of) multiple aggregations (COUNT, SUM) on a single report, which is kind of a bummer.   You can also try a pivot table on some trivial condition (Created at for before tomorrow, for example), with a sum on the cost column.   If you hover over the number, you'll see a record count of how many there are.

Other than that, I think you'll have to resort to creating your own custom UI Page or something.

[richofing]

I am actually starting to think I might need to use Crystal Reports because I also need some fairly complex formatting for headers and footers, logo, etc.

Ric

[nag2042 · Accepted solution]

Hi Richard,

Right Click on Cost field n the report and click on Configure and select List Calculations

You have multiple options to perform

If this is what you are looking for then mark it as answer